/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50136
Source Host           : localhost:3306
Source Database       : db_sys_mypes

Target Server Type    : MYSQL
Target Server Version : 50136
File Encoding         : 65001

Date: 2013-03-26 00:54:50
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Records of tb_catalogo
-- ----------------------------
BEGIN;
INSERT INTO `tb_catalogo` VALUES ('1', '001', '000', 'SEXO', '0', '1'), ('2', '001', '001', 'MASCULINO', '1', '1'), ('3', '001', '002', 'FEMENINO', '2', '1'), ('4', '002', '000', 'TIPO PROVEEDOR', '0', '1'), ('5', '002', '001', 'JURÍDICO', '1', '1'), ('6', '002', '002', 'NATURAL', '1', '1'), ('7', '001', '003', 'UNISEX / NO DETERMINADO', '3', '1'), ('8', '003', '000', 'TIPO USUARIO', '0', '1'), ('9', '003', '001', 'ADMINISTRADOR', '1', '1'), ('10', '003', '002', 'CAJA', '2', '1'), ('11', '003', '003', 'VENDEDOR', '3', '1'), ('12', '004', '000', 'TALLAS', '0', '1'), ('13', '004', '001', '2', '1', '1'), ('14', '004', '002', '4', '2', '1'), ('15', '004', '003', '6', '3', '1'), ('16', '004', '004', '8', '4', '1'), ('17', '004', '005', '10', '5', '1'), ('18', '004', '006', '12', '6', '1'), ('19', '004', '007', '14', '7', '1'), ('20', '004', '008', '16', '8', '1'), ('21', '004', '009', 'S', '9', '1'), ('22', '004', '010', 'M', '10', '1'), ('23', '004', '011', 'L', '11', '1'), ('24', '004', '012', 'XL', '12', '1'), ('25', '005', '000', 'COLORES', '0', '1'), ('26', '005', '001', 'ROJO', '1', '1'), ('27', '005', '002', 'AZUL', '2', '1'), ('28', '005', '003', 'VERDE', '3', '1'), ('29', '005', '004', 'MARRÓN', '4', '1'), ('30', '005', '005', 'AMARILLO', '5', '1'), ('31', '006', '000', 'ESTADO VENTA', '0', '1'), ('32', '006', '001', 'ANULADA', '1', '1'), ('33', '006', '002', 'PENDIENTE', '2', '1'), ('34', '006', '003', 'EFECTUADA', '3', '1');
COMMIT;

-- ----------------------------
-- Records of tb_categoria
-- ----------------------------
BEGIN;
INSERT INTO `tb_categoria` VALUES ('1', 'Pantalones', '1'), ('2', 'Camisas', '1'), ('3', 'Vestidos', '1'), ('4', 'Chompas', '1'), ('5', 'Casacas', '1');
COMMIT;

-- ----------------------------
-- Records of tb_cliente
-- ----------------------------
BEGIN;
INSERT INTO `tb_cliente` VALUES ('1', 'JOSÉ ABELARDO', 'TEJADA', 'VILCA', '42513669', 'jtejadavilca@gmail.com', '150101', 'Jr. granaderos N° 172 - Cercado de Lima', 'Alt. cdra 5 de Av. Morales Duárez', '001001', '4316658', '987597372', null, '1984-04-30', '1'), ('2', 'LINDA SARAMI', 'HUARANGA', 'PAREDES', '45749541', 'sarami_hpq@hotmail.com', '150101', 'Jr. Legion Peruana 231', 'Altra. cuadra 6 Av. Morales Duarez', '001002', '4316658', '991368783', null, '1989-05-08', '1'), ('3', 'PETER KOE', 'VASQUEZ', 'SOTELO', '12345679', 'peter_19@hotmail.com', '150101', 'Av. Tomas Valle 111', null, '001001', '4315588', '999999999', null, '1990-12-13', '0'), ('4', 'JORGE', 'PINEDO', 'DIESTRA', '12356448', 'peneq@hotmail.com', '150101', 'lima', 'lima', '001001', '12345698', '989898989', null, '2012-11-15', '0'), ('5', 'JUAN', 'PEREZ', 'ROJAS', '4658897', 'cliente@gmail.com', '150101', 'AV. PERU 123', 'DUEÑAS', '001001', '4658898', '985689874', null, '2013-03-13', '1');
COMMIT;

-- ----------------------------
-- Records of tb_distrito
-- ----------------------------
BEGIN;
INSERT INTO `tb_distrito` VALUES ('000000', 'NO ESPECIFICA', '0000', '00'), ('010000', 'AMAZONAS', '0100', '01'), ('010100', 'CHACHAPOYAS', '0101', '01'), ('010101', 'CHACHAPOYAS', '0101', '01'), ('010102', 'ASUNCION', '0101', '01'), ('010103', 'BALSAS', '0101', '01'), ('010104', 'CHETO', '0101', '01'), ('010105', 'CHILIQUIN', '0101', '01'), ('010106', 'CHUQUIBAMBA', '0101', '01'), ('010107', 'GRANADA', '0101', '01'), ('010108', 'HUANCAS', '0101', '01'), ('010109', 'LA JALCA', '0101', '01'), ('010110', 'LEIMEBAMBA', '0101', '01'), ('010111', 'LEVANTO', '0101', '01'), ('010112', 'MAGDALENA', '0101', '01'), ('010113', 'MARISCAL CASTILLA', '0101', '01'), ('010114', 'MOLINOPAMPA', '0101', '01'), ('010115', 'MONTEVIDEO', '0101', '01'), ('010116', 'OLLEROS', '0101', '01'), ('010117', 'QUINJALCA', '0101', '01'), ('010118', 'SAN FRANCISCO DE DAGUAS', '0101', '01'), ('010119', 'SAN ISIDRO DE MAINO', '0101', '01'), ('010120', 'SOLOCO', '0101', '01'), ('010121', 'SONCHE', '0101', '01'), ('010200', 'BAGUA', '0102', '01'), ('010201', 'LA PECA', '0102', '01'), ('010202', 'ARAMANGO', '0102', '01'), ('010203', 'COPALLIN', '0102', '01'), ('010204', 'EL PARCO', '0102', '01'), ('010205', 'IMAZA', '0102', '01'), ('010300', 'BONGARA', '0103', '01'), ('010301', 'JUMBILLA', '0103', '01'), ('010302', 'CHISQUILLA', '0103', '01'), ('010303', 'CHURUJA', '0103', '01'), ('010304', 'COROSHA', '0103', '01'), ('010305', 'CUISPES', '0103', '01'), ('010306', 'FLORIDA', '0103', '01'), ('010307', 'JAZAN', '0103', '01'), ('010308', 'RECTA', '0103', '01'), ('010309', 'SAN CARLOS', '0103', '01'), ('010310', 'SHIPASBAMBA', '0103', '01'), ('010311', 'VALERA', '0103', '01'), ('010312', 'YAMBRASBAMBA', '0103', '01'), ('010400', 'CONDORCANQUI', '0104', '01'), ('010401', 'NIEVA', '0104', '01'), ('010402', 'EL CENEPA', '0104', '01'), ('010403', 'RIO SANTIAGO', '0104', '01'), ('010500', 'LUYA', '0105', '01'), ('010501', 'LAMUD', '0105', '01'), ('010502', 'CAMPORREDONDO', '0105', '01'), ('010503', 'COCABAMBA', '0105', '01'), ('010504', 'COLCAMAR', '0105', '01'), ('010505', 'CONILA', '0105', '01'), ('010506', 'INGUILPATA', '0105', '01'), ('010507', 'LONGUITA', '0105', '01'), ('010508', 'LONYA CHICO', '0105', '01'), ('010509', 'LUYA', '0105', '01'), ('010510', 'LUYA VIEJO', '0105', '01'), ('010511', 'MARIA', '0105', '01'), ('010512', 'OCALLI', '0105', '01'), ('010513', 'OCUMAL', '0105', '01'), ('010514', 'PISUQUIA', '0105', '01'), ('010515', 'PROVIDENCIA', '0105', '01'), ('010516', 'SAN CRISTOBAL', '0105', '01'), ('010517', 'SAN FRANCISCO DEL YESO', '0105', '01'), ('010518', 'SAN JERONIMO', '0105', '01'), ('010519', 'SAN JUAN DE LOPECANCHA', '0105', '01'), ('010520', 'SANTA CATALINA', '0105', '01'), ('010521', 'SANTO TOMAS', '0105', '01'), ('010522', 'TINGO', '0105', '01'), ('010523', 'TRITA', '0105', '01'), ('010600', 'RODRIGUEZ DE MENDOZA', '0106', '01'), ('010601', 'SAN NICOLAS', '0106', '01'), ('010602', 'CHIRIMOTO', '0106', '01'), ('010603', 'COCHAMAL', '0106', '01'), ('010604', 'HUAMBO', '0106', '01'), ('010605', 'LIMABAMBA', '0106', '01'), ('010606', 'LONGAR', '0106', '01'), ('010607', 'MARISCAL BENAVIDES', '0106', '01'), ('010608', 'MILPUC', '0106', '01'), ('010609', 'OMIA', '0106', '01'), ('010610', 'SANTA ROSA', '0106', '01'), ('010611', 'TOTORA', '0106', '01'), ('010612', 'VISTA ALEGRE', '0106', '01'), ('010700', 'UTCUBAMBA', '0107', '01'), ('010701', 'BAGUA GRANDE', '0107', '01'), ('010702', 'CAJARURO', '0107', '01'), ('010703', 'CUMBA', '0107', '01'), ('010704', 'EL MILAGRO', '0107', '01'), ('010705', 'JAMALCA', '0107', '01'), ('010706', 'LONYA GRANDE', '0107', '01'), ('010707', 'YAMON', '0107', '01'), ('020000', 'ANCASH', '0200', '02'), ('020100', 'HUARAZ', '0201', '02'), ('020101', 'HUARAZ', '0201', '02'), ('020102', 'COCHABAMBA', '0201', '02'), ('020103', 'COLCABAMBA', '0201', '02'), ('020104', 'HUANCHAY', '0201', '02'), ('020105', 'INDEPENDENCIA', '0201', '02'), ('020106', 'JANGAS', '0201', '02'), ('020107', 'LA LIBERTAD', '0201', '02');
INSERT INTO `tb_distrito` VALUES ('020108', 'OLLEROS', '0201', '02'), ('020109', 'PAMPAS', '0201', '02'), ('020110', 'PARIACOTO', '0201', '02'), ('020111', 'PIRA', '0201', '02'), ('020112', 'TARICA', '0201', '02'), ('020200', 'AIJA', '0202', '02'), ('020201', 'AIJA', '0202', '02'), ('020202', 'CORIS', '0202', '02'), ('020203', 'HUACLLAN', '0202', '02'), ('020204', 'LA MERCED', '0202', '02'), ('020205', 'SUCCHA', '0202', '02'), ('020300', 'ANTONIO RAYMONDI', '0203', '02'), ('020301', 'LLAMELLIN', '0203', '02'), ('020302', 'ACZO', '0203', '02'), ('020303', 'CHACCHO', '0203', '02'), ('020304', 'CHINGAS', '0203', '02'), ('020305', 'MIRGAS', '0203', '02'), ('020306', 'SAN JUAN DE RONTOY', '0203', '02'), ('020400', 'ASUNCION', '0204', '02'), ('020401', 'CHACAS', '0204', '02'), ('020402', 'ACOCHACA', '0204', '02'), ('020500', 'BOLOGNESI', '0205', '02'), ('020501', 'CHIQUIAN', '0205', '02'), ('020502', 'ABELARDO PARDO LEZAMETA', '0205', '02'), ('020503', 'ANTONIO RAYMONDI', '0205', '02'), ('020504', 'AQUIA', '0205', '02'), ('020505', 'CAJACAY', '0205', '02'), ('020506', 'CANIS', '0205', '02'), ('020507', 'COLQUIOC', '0205', '02'), ('020508', 'HUALLANCA', '0205', '02'), ('020509', 'HUASTA', '0205', '02'), ('020510', 'HUAYLLACAYAN', '0205', '02'), ('020511', 'LA PRIMAVERA', '0205', '02'), ('020512', 'MANGAS', '0205', '02'), ('020513', 'PACLLON', '0205', '02'), ('020514', 'SAN MIGUEL DE CORPANQUI', '0205', '02'), ('020515', 'TICLLOS', '0205', '02'), ('020600', 'CARHUAZ', '0206', '02'), ('020601', 'CARHUAZ', '0206', '02'), ('020602', 'ACOPAMPA', '0206', '02'), ('020603', 'AMASHCA', '0206', '02'), ('020604', 'ANTA', '0206', '02'), ('020605', 'ATAQUERO', '0206', '02'), ('020606', 'MARCARA', '0206', '02'), ('020607', 'PARIAHUANCA', '0206', '02'), ('020608', 'SAN MIGUEL DE ACO', '0206', '02'), ('020609', 'SHILLA', '0206', '02'), ('020610', 'TINCO', '0206', '02'), ('020611', 'YUNGAR', '0206', '02'), ('020700', 'CARLOS F. FITZCARRALD', '0207', '02'), ('020701', 'SAN LUIS', '0207', '02'), ('020702', 'SAN NICOLAS', '0207', '02'), ('020703', 'YAUYA', '0207', '02'), ('020800', 'CASMA', '0208', '02'), ('020801', 'CASMA', '0208', '02'), ('020802', 'BUENA VISTA ALTA', '0208', '02'), ('020803', 'COMANDANTE NOEL', '0208', '02'), ('020804', 'YAUTAN', '0208', '02'), ('020900', 'CORONGO', '0209', '02'), ('020901', 'CORONGO', '0209', '02'), ('020902', 'ACO', '0209', '02'), ('020903', 'BAMBAS', '0209', '02'), ('020904', 'CUSCA', '0209', '02'), ('020905', 'LA PAMPA', '0209', '02'), ('020906', 'YANAC', '0209', '02'), ('020907', 'YUPAN', '0209', '02'), ('021000', 'HUARI', '0210', '02'), ('021001', 'HUARI', '0210', '02'), ('021002', 'ANRA', '0210', '02'), ('021003', 'CAJAY', '0210', '02'), ('021004', 'CHAVIN DE HUANTAR', '0210', '02'), ('021005', 'HUACACHI', '0210', '02'), ('021006', 'HUACCHIS', '0210', '02'), ('021007', 'HUACHIS', '0210', '02'), ('021008', 'HUANTAR', '0210', '02'), ('021009', 'MASIN', '0210', '02'), ('021010', 'PAUCAS', '0210', '02'), ('021011', 'PONTO', '0210', '02'), ('021012', 'RAHUAPAMPA', '0210', '02'), ('021013', 'RAPAYAN', '0210', '02'), ('021014', 'SAN MARCOS', '0210', '02'), ('021015', 'SAN PEDRO DE CHANA', '0210', '02'), ('021016', 'UCO', '0210', '02'), ('021100', 'HUARMEY', '0211', '02'), ('021101', 'HUARMEY', '0211', '02'), ('021102', 'COCHAPETI', '0211', '02'), ('021103', 'CULEBRAS', '0211', '02'), ('021104', 'HUAYAN', '0211', '02'), ('021105', 'MALVAS', '0211', '02'), ('021200', 'HUAYLAS', '0212', '02'), ('021201', 'CARAZ', '0212', '02'), ('021202', 'HUALLANCA', '0212', '02'), ('021203', 'HUATA', '0212', '02'), ('021204', 'HUAYLAS', '0212', '02'), ('021205', 'MATO', '0212', '02'), ('021206', 'PAMPAROMAS', '0212', '02'), ('021207', 'PUEBLO LIBRE', '0212', '02'), ('021208', 'SANTA CRUZ', '0212', '02'), ('021209', 'SANTO TORIBIO', '0212', '02'), ('021210', 'YURACMARCA', '0212', '02'), ('021300', 'MARISCAL LUZURIAGA', '0213', '02');
INSERT INTO `tb_distrito` VALUES ('021301', 'PISCOBAMBA', '0213', '02'), ('021302', 'CASCA', '0213', '02'), ('021303', 'ELEAZAR GUZMAN BARRON', '0213', '02'), ('021304', 'FIDEL OLIVAS ESCUDERO', '0213', '02'), ('021305', 'LLAMA', '0213', '02'), ('021306', 'LLUMPA', '0213', '02'), ('021307', 'LUCMA', '0213', '02'), ('021308', 'MUSGA', '0213', '02'), ('021400', 'OCROS', '0214', '02'), ('021401', 'OCROS', '0214', '02'), ('021402', 'ACAS', '0214', '02'), ('021403', 'CAJAMARQUILLA', '0214', '02'), ('021404', 'CARHUAPAMPA', '0214', '02'), ('021405', 'COCHAS', '0214', '02'), ('021406', 'CONGAS', '0214', '02'), ('021407', 'LLIPA', '0214', '02'), ('021408', 'SAN CRISTOBAL DE RAJAN', '0214', '02'), ('021409', 'SAN PEDRO', '0214', '02'), ('021410', 'SANTIAGO DE CHILCAS', '0214', '02'), ('021500', 'PALLASCA', '0215', '02'), ('021501', 'CABANA', '0215', '02'), ('021502', 'BOLOGNESI', '0215', '02'), ('021503', 'CONCHUCOS', '0215', '02'), ('021504', 'HUACASCHUQUE', '0215', '02'), ('021505', 'HUANDOVAL', '0215', '02'), ('021506', 'LACABAMBA', '0215', '02'), ('021507', 'LLAPO', '0215', '02'), ('021508', 'PALLASCA', '0215', '02'), ('021509', 'PAMPAS', '0215', '02'), ('021510', 'SANTA ROSA', '0215', '02'), ('021511', 'TAUCA', '0215', '02'), ('021600', 'POMABAMBA', '0216', '02'), ('021601', 'POMABAMBA', '0216', '02'), ('021602', 'HUAYLLAN', '0216', '02'), ('021603', 'PAROBAMBA', '0216', '02'), ('021604', 'QUINUABAMBA', '0216', '02'), ('021700', 'RECUAY', '0217', '02'), ('021701', 'RECUAY', '0217', '02'), ('021702', 'CATAC', '0217', '02'), ('021703', 'COTAPARACO', '0217', '02'), ('021704', 'HUAYLLAPAMPA', '0217', '02'), ('021705', 'LLACLLIN', '0217', '02'), ('021706', 'MARCA', '0217', '02'), ('021707', 'PAMPAS CHICO', '0217', '02'), ('021708', 'PARARIN', '0217', '02'), ('021709', 'TAPACOCHA', '0217', '02'), ('021710', 'TICAPAMPA', '0217', '02'), ('021800', 'SANTA', '0218', '02'), ('021801', 'CHIMBOTE', '0218', '02'), ('021802', 'CACERES DEL PERU', '0218', '02'), ('021803', 'COISHCO', '0218', '02'), ('021804', 'MACATE', '0218', '02'), ('021805', 'MORO', '0218', '02'), ('021806', 'NEPEÑA', '0218', '02'), ('021807', 'SAMANCO', '0218', '02'), ('021808', 'SANTA', '0218', '02'), ('021809', 'NUEVO CHIMBOTE', '0218', '02'), ('021900', 'SIHUAS', '0219', '02'), ('021901', 'SIHUAS', '0219', '02'), ('021902', 'ACOBAMBA', '0219', '02'), ('021903', 'ALFONSO UGARTE', '0219', '02'), ('021904', 'CASHAPAMPA', '0219', '02'), ('021905', 'CHINGALPO', '0219', '02'), ('021906', 'HUAYLLABAMBA', '0219', '02'), ('021907', 'QUICHES', '0219', '02'), ('021908', 'RAGASH', '0219', '02'), ('021909', 'SAN JUAN', '0219', '02'), ('021910', 'SICSIBAMBA', '0219', '02'), ('022000', 'YUNGAY', '0220', '02'), ('022001', 'YUNGAY', '0220', '02'), ('022002', 'CASCAPARA', '0220', '02'), ('022003', 'MANCOS', '0220', '02'), ('022004', 'MATACOTO', '0220', '02'), ('022005', 'QUILLO', '0220', '02'), ('022006', 'RANRAHIRCA', '0220', '02'), ('022007', 'SHUPLUY', '0220', '02'), ('022008', 'YANAMA', '0220', '02'), ('030000', 'APURIMAC', '0300', '03'), ('030100', 'ABANCAY', '0301', '03'), ('030101', 'ABANCAY', '0301', '03'), ('030102', 'CHACOCHE', '0301', '03'), ('030103', 'CIRCA', '0301', '03'), ('030104', 'CURAHUASI', '0301', '03'), ('030105', 'HUANIPACA', '0301', '03'), ('030106', 'LAMBRAMA', '0301', '03'), ('030107', 'PICHIRHUA', '0301', '03'), ('030108', 'SAN PEDRO DE CACHORA', '0301', '03'), ('030109', 'TAMBURCO', '0301', '03'), ('030200', 'ANDAHUAYLAS', '0302', '03'), ('030201', 'ANDAHUAYLAS', '0302', '03'), ('030202', 'ANDARAPA', '0302', '03'), ('030203', 'CHIARA', '0302', '03'), ('030204', 'HUANCARAMA', '0302', '03'), ('030205', 'HUANCARAY', '0302', '03'), ('030206', 'HUAYANA', '0302', '03'), ('030207', 'KISHUARA', '0302', '03'), ('030208', 'PACOBAMBA', '0302', '03'), ('030209', 'PACUCHA', '0302', '03'), ('030210', 'PAMPACHIRI', '0302', '03'), ('030211', 'POMACOCHA', '0302', '03'), ('030212', 'SAN ANTONIO DE CACHI', '0302', '03');
INSERT INTO `tb_distrito` VALUES ('030213', 'SAN JERONIMO', '0302', '03'), ('030214', 'SAN MIGUEL DE CHACCRAMPA', '0302', '03'), ('030215', 'SANTA MARIA DE CHICMO', '0302', '03'), ('030216', 'TALAVERA', '0302', '03'), ('030217', 'TUMAY HUARACA', '0302', '03'), ('030218', 'TURPO', '0302', '03'), ('030219', 'KAQUIABAMBA', '0302', '03'), ('030300', 'ANTABAMBA', '0303', '03'), ('030301', 'ANTABAMBA', '0303', '03'), ('030302', 'EL ORO', '0303', '03'), ('030303', 'HUAQUIRCA', '0303', '03'), ('030304', 'JUAN ESPINOZA MEDRANO', '0303', '03'), ('030305', 'OROPESA', '0303', '03'), ('030306', 'PACHACONAS', '0303', '03'), ('030307', 'SABAINO', '0303', '03'), ('030400', 'AYMARAES', '0304', '03'), ('030401', 'CHALHUANCA', '0304', '03'), ('030402', 'CAPAYA', '0304', '03'), ('030403', 'CARAYBAMBA', '0304', '03'), ('030404', 'CHAPIMARCA', '0304', '03'), ('030405', 'COLCABAMBA', '0304', '03'), ('030406', 'COTARUSE', '0304', '03'), ('030407', 'HUAYLLO', '0304', '03'), ('030408', 'JUSTO APU SAHUARAURA', '0304', '03'), ('030409', 'LUCRE', '0304', '03'), ('030410', 'POCOHUANCA', '0304', '03'), ('030411', 'SAN JUAN DE CHACÑA', '0304', '03'), ('030412', 'SAÑAYCA', '0304', '03'), ('030413', 'SORAYA', '0304', '03'), ('030414', 'TAPAIRIHUA', '0304', '03'), ('030415', 'TINTAY', '0304', '03'), ('030416', 'TORAYA', '0304', '03'), ('030417', 'YANACA', '0304', '03'), ('030500', 'COTABAMBAS', '0305', '03'), ('030501', 'TAMBOBAMBA', '0305', '03'), ('030502', 'COTABAMBAS', '0305', '03'), ('030503', 'COYLLURQUI', '0305', '03'), ('030504', 'HAQUIRA', '0305', '03'), ('030505', 'MARA', '0305', '03'), ('030506', 'CHALLHUAHUACHO', '0305', '03'), ('030600', 'CHINCHEROS', '0306', '03'), ('030601', 'CHINCHEROS', '0306', '03'), ('030602', 'ANCO-HUALLO', '0306', '03'), ('030603', 'COCHARCAS', '0306', '03'), ('030604', 'HUACCANA', '0306', '03'), ('030605', 'OCOBAMBA', '0306', '03'), ('030606', 'ONGOY', '0306', '03'), ('030607', 'URANMARCA', '0306', '03'), ('030608', 'RANRACANCHA', '0306', '03'), ('030700', 'GRAU', '0307', '03'), ('030701', 'CHUQUIBAMBILLA', '0307', '03'), ('030702', 'CURPAHUASI', '0307', '03'), ('030703', 'GAMARRA', '0307', '03'), ('030704', 'HUAYLLATI', '0307', '03'), ('030705', 'MAMARA', '0307', '03'), ('030706', 'MICAELA BASTIDAS', '0307', '03'), ('030707', 'PATAYPAMPA', '0307', '03'), ('030708', 'PROGRESO', '0307', '03'), ('030709', 'SAN ANTONIO', '0307', '03'), ('030710', 'SANTA ROSA', '0307', '03'), ('030711', 'TURPAY', '0307', '03'), ('030712', 'VILCABAMBA', '0307', '03'), ('030713', 'VIRUNDO', '0307', '03'), ('030714', 'CURASCO', '0307', '03'), ('040000', 'AREQUIPA', '0400', '04'), ('040100', 'AREQUIPA', '0401', '04'), ('040101', 'AREQUIPA', '0401', '04'), ('040102', 'ALTO SELVA ALEGRE', '0401', '04'), ('040103', 'CAYMA', '0401', '04'), ('040104', 'CERRO COLORADO', '0401', '04'), ('040105', 'CHARACATO', '0401', '04'), ('040106', 'CHIGUATA', '0401', '04'), ('040107', 'JACOBO HUNTER', '0401', '04'), ('040108', 'LA JOYA', '0401', '04'), ('040109', 'MARIANO MELGAR', '0401', '04'), ('040110', 'MIRAFLORES', '0401', '04'), ('040111', 'MOLLEBAYA', '0401', '04'), ('040112', 'PAUCARPATA', '0401', '04'), ('040113', 'POCSI', '0401', '04'), ('040114', 'POLOBAYA', '0401', '04'), ('040115', 'QUEQUEÑA', '0401', '04'), ('040116', 'SABANDIA', '0401', '04'), ('040117', 'SACHACA', '0401', '04'), ('040118', 'SAN JUAN DE SIGUAS', '0401', '04'), ('040119', 'SAN JUAN DE TARUCANI', '0401', '04'), ('040120', 'SANTA ISABEL DE SIGUAS', '0401', '04'), ('040121', 'SANTA RITA DE SIGUAS', '0401', '04'), ('040122', 'SOCABAYA', '0401', '04'), ('040123', 'TIABAYA', '0401', '04'), ('040124', 'UCHUMAYO', '0401', '04'), ('040125', 'VITOR', '0401', '04'), ('040126', 'YANAHUARA', '0401', '04'), ('040127', 'YARABAMBA', '0401', '04'), ('040128', 'YURA', '0401', '04'), ('040129', 'JOSE LUIS BUSTAMANTE Y RIVERO', '0401', '04'), ('040200', 'CAMANA', '0402', '04'), ('040201', 'CAMANA', '0402', '04'), ('040202', 'JOSE MARIA QUIMPER', '0402', '04'), ('040203', 'MARIANO NICOLAS VALCARCEL', '0402', '04'), ('040204', 'MARISCAL CACERES', '0402', '04'), ('040205', 'NICOLAS DE PIEROLA', '0402', '04');
INSERT INTO `tb_distrito` VALUES ('040206', 'OCOÑA', '0402', '04'), ('040207', 'QUILCA', '0402', '04'), ('040208', 'SAMUEL PASTOR', '0402', '04'), ('040300', 'CARAVELI', '0403', '04'), ('040301', 'CARAVELI', '0403', '04'), ('040302', 'ACARI', '0403', '04'), ('040303', 'ATICO', '0403', '04'), ('040304', 'ATIQUIPA', '0403', '04'), ('040305', 'BELLA UNION', '0403', '04'), ('040306', 'CAHUACHO', '0403', '04'), ('040307', 'CHALA', '0403', '04'), ('040308', 'CHAPARRA', '0403', '04'), ('040309', 'HUANUHUANU', '0403', '04'), ('040310', 'JAQUI', '0403', '04'), ('040311', 'LOMAS', '0403', '04'), ('040312', 'QUICACHA', '0403', '04'), ('040313', 'YAUCA', '0403', '04'), ('040400', 'CASTILLA', '0404', '04'), ('040401', 'APLAO', '0404', '04'), ('040402', 'ANDAGUA', '0404', '04'), ('040403', 'AYO', '0404', '04'), ('040404', 'CHACHAS', '0404', '04'), ('040405', 'CHILCAYMARCA', '0404', '04'), ('040406', 'CHOCO', '0404', '04'), ('040407', 'HUANCARQUI', '0404', '04'), ('040408', 'MACHAGUAY', '0404', '04'), ('040409', 'ORCOPAMPA', '0404', '04'), ('040410', 'PAMPACOLCA', '0404', '04'), ('040411', 'TIPAN', '0404', '04'), ('040412', 'UÑON', '0404', '04'), ('040413', 'URACA', '0404', '04'), ('040414', 'VIRACO', '0404', '04'), ('040500', 'CAYLLOMA', '0405', '04'), ('040501', 'CHIVAY', '0405', '04'), ('040502', 'ACHOMA', '0405', '04'), ('040503', 'CABANACONDE', '0405', '04'), ('040504', 'CALLALLI', '0405', '04'), ('040505', 'CAYLLOMA', '0405', '04'), ('040506', 'COPORAQUE', '0405', '04'), ('040507', 'HUAMBO', '0405', '04'), ('040508', 'HUANCA', '0405', '04'), ('040509', 'ICHUPAMPA', '0405', '04'), ('040510', 'LARI', '0405', '04'), ('040511', 'LLUTA', '0405', '04'), ('040512', 'MACA', '0405', '04'), ('040513', 'MADRIGAL', '0405', '04'), ('040514', 'SAN ANTONIO DE CHUCA', '0405', '04'), ('040515', 'SIBAYO', '0405', '04'), ('040516', 'TAPAY', '0405', '04'), ('040517', 'TISCO', '0405', '04'), ('040518', 'TUTI', '0405', '04'), ('040519', 'YANQUE', '0405', '04'), ('040520', 'MAJES', '0405', '04'), ('040600', 'CONDESUYOS', '0406', '04'), ('040601', 'CHUQUIBAMBA', '0406', '04'), ('040602', 'ANDARAY', '0406', '04'), ('040603', 'CAYARANI', '0406', '04'), ('040604', 'CHICHAS', '0406', '04'), ('040605', 'IRAY', '0406', '04'), ('040606', 'RIO GRANDE', '0406', '04'), ('040607', 'SALAMANCA', '0406', '04'), ('040608', 'YANAQUIHUA', '0406', '04'), ('040700', 'ISLAY', '0407', '04'), ('040701', 'MOLLENDO', '0407', '04'), ('040702', 'COCACHACRA', '0407', '04'), ('040703', 'DEAN VALDIVIA', '0407', '04'), ('040704', 'ISLAY', '0407', '04'), ('040705', 'MEJIA', '0407', '04'), ('040706', 'PUNTA DE BOMBON', '0407', '04'), ('040800', 'LA UNION', '0408', '04'), ('040801', 'COTAHUASI', '0408', '04'), ('040802', 'ALCA', '0408', '04'), ('040803', 'CHARCANA', '0408', '04'), ('040804', 'HUAYNACOTAS', '0408', '04'), ('040805', 'PAMPAMARCA', '0408', '04'), ('040806', 'PUYCA', '0408', '04'), ('040807', 'QUECHUALLA', '0408', '04'), ('040808', 'SAYLA', '0408', '04'), ('040809', 'TAURIA', '0408', '04'), ('040810', 'TOMEPAMPA', '0408', '04'), ('040811', 'TORO', '0408', '04'), ('050000', 'AYACUCHO', '0500', '05'), ('050100', 'HUAMANGA', '0501', '05'), ('050101', 'AYACUCHO', '0501', '05'), ('050102', 'ACOCRO', '0501', '05'), ('050103', 'ACOS VINCHOS', '0501', '05'), ('050104', 'CARMEN ALTO', '0501', '05'), ('050105', 'CHIARA', '0501', '05'), ('050106', 'OCROS', '0501', '05'), ('050107', 'PACAYCASA', '0501', '05'), ('050108', 'QUINUA', '0501', '05'), ('050109', 'SAN JOSE DE TICLLAS', '0501', '05'), ('050110', 'SAN JUAN BAUTISTA', '0501', '05'), ('050111', 'SANTIAGO DE PISCHA', '0501', '05'), ('050112', 'SOCOS', '0501', '05'), ('050113', 'TAMBILLO', '0501', '05'), ('050114', 'VINCHOS', '0501', '05'), ('050115', 'JESUS NAZARENO', '0501', '05'), ('050200', 'CANGALLO', '0502', '05'), ('050201', 'CANGALLO', '0502', '05'), ('050202', 'CHUSCHI', '0502', '05');
INSERT INTO `tb_distrito` VALUES ('050203', 'LOS MOROCHUCOS', '0502', '05'), ('050204', 'MARIA PARADO DE BELLIDO', '0502', '05'), ('050205', 'PARAS', '0502', '05'), ('050206', 'TOTOS', '0502', '05'), ('050300', 'HUANCA SANCOS', '0503', '05'), ('050301', 'SANCOS', '0503', '05'), ('050302', 'CARAPO', '0503', '05'), ('050303', 'SACSAMARCA', '0503', '05'), ('050304', 'SANTIAGO DE LUCANAMARCA', '0503', '05'), ('050400', 'HUANTA', '0504', '05'), ('050401', 'HUANTA', '0504', '05'), ('050402', 'AYAHUANCO', '0504', '05'), ('050403', 'HUAMANGUILLA', '0504', '05'), ('050404', 'IGUAIN', '0504', '05'), ('050405', 'LURICOCHA', '0504', '05'), ('050406', 'SANTILLANA', '0504', '05'), ('050407', 'SIVIA', '0504', '05'), ('050408', 'LLOCHEGUA', '0504', '05'), ('050500', 'LA MAR', '0505', '05'), ('050501', 'SAN MIGUEL', '0505', '05'), ('050502', 'ANCO', '0505', '05'), ('050503', 'AYNA', '0505', '05'), ('050504', 'CHILCAS', '0505', '05'), ('050505', 'CHUNGUI', '0505', '05'), ('050506', 'LUIS CARRANZA', '0505', '05'), ('050507', 'SANTA ROSA', '0505', '05'), ('050508', 'TAMBO', '0505', '05'), ('050600', 'LUCANAS', '0506', '05'), ('050601', 'PUQUIO', '0506', '05'), ('050602', 'AUCARA', '0506', '05'), ('050603', 'CABANA', '0506', '05'), ('050604', 'CARMEN SALCEDO', '0506', '05'), ('050605', 'CHAVIÑA', '0506', '05'), ('050606', 'CHIPAO', '0506', '05'), ('050607', 'HUAC-HUAS', '0506', '05'), ('050608', 'LARAMATE', '0506', '05'), ('050609', 'LEONCIO PRADO', '0506', '05'), ('050610', 'LLAUTA', '0506', '05'), ('050611', 'LUCANAS', '0506', '05'), ('050612', 'OCAÑA', '0506', '05'), ('050613', 'OTOCA', '0506', '05'), ('050614', 'SAISA', '0506', '05'), ('050615', 'SAN CRISTOBAL', '0506', '05'), ('050616', 'SAN JUAN', '0506', '05'), ('050617', 'SAN PEDRO', '0506', '05'), ('050618', 'SAN PEDRO DE PALCO', '0506', '05'), ('050619', 'SANCOS', '0506', '05'), ('050620', 'SANTA ANA DE HUAYCAHUACHO', '0506', '05'), ('050621', 'SANTA LUCIA', '0506', '05'), ('050700', 'PARINACOCHAS', '0507', '05'), ('050701', 'CORACORA', '0507', '05'), ('050702', 'CHUMPI', '0507', '05'), ('050703', 'CORONEL CASTAÑEDA', '0507', '05'), ('050704', 'PACAPAUSA', '0507', '05'), ('050705', 'PULLO', '0507', '05'), ('050706', 'PUYUSCA', '0507', '05'), ('050707', 'SAN FRANCISCO DE RAVACAYCO', '0507', '05'), ('050708', 'UPAHUACHO', '0507', '05'), ('050800', 'PAUCAR DEL SARA SARA', '0508', '05'), ('050801', 'PAUSA', '0508', '05'), ('050802', 'COLTA', '0508', '05'), ('050803', 'CORCULLA', '0508', '05'), ('050804', 'LAMPA', '0508', '05'), ('050805', 'MARCABAMBA', '0508', '05'), ('050806', 'OYOLO', '0508', '05'), ('050807', 'PARARCA', '0508', '05'), ('050808', 'SAN JAVIER DE ALPABAMBA', '0508', '05'), ('050809', 'SAN JOSE DE USHUA', '0508', '05'), ('050810', 'SARA SARA', '0508', '05'), ('050900', 'SUCRE', '0509', '05'), ('050901', 'QUEROBAMBA', '0509', '05'), ('050902', 'BELEN', '0509', '05'), ('050903', 'CHALCOS', '0509', '05'), ('050904', 'CHILCAYOC', '0509', '05'), ('050905', 'HUACAÑA', '0509', '05'), ('050906', 'MORCOLLA', '0509', '05'), ('050907', 'PAICO', '0509', '05'), ('050908', 'SAN PEDRO DE LARCAY', '0509', '05'), ('050909', 'SAN SALVADOR DE QUIJE', '0509', '05'), ('050910', 'SANTIAGO DE PAUCARAY', '0509', '05'), ('050911', 'SORAS', '0509', '05'), ('051000', 'VICTOR FAJARDO', '0510', '05'), ('051001', 'HUANCAPI', '0510', '05'), ('051002', 'ALCAMENCA', '0510', '05'), ('051003', 'APONGO', '0510', '05'), ('051004', 'ASQUIPATA', '0510', '05'), ('051005', 'CANARIA', '0510', '05'), ('051006', 'CAYARA', '0510', '05'), ('051007', 'COLCA', '0510', '05'), ('051008', 'HUAMANQUIQUIA', '0510', '05'), ('051009', 'HUANCARAYLLA', '0510', '05'), ('051010', 'HUAYA', '0510', '05'), ('051011', 'SARHUA', '0510', '05'), ('051012', 'VILCANCHOS', '0510', '05'), ('051100', 'VILCAS HUAMAN', '0511', '05'), ('051101', 'VILCAS HUAMAN', '0511', '05'), ('051102', 'ACCOMARCA', '0511', '05'), ('051103', 'CARHUANCA', '0511', '05'), ('051104', 'CONCEPCION', '0511', '05'), ('051105', 'HUAMBALPA', '0511', '05'), ('051106', 'INDEPENDENCIA', '0511', '05');
INSERT INTO `tb_distrito` VALUES ('051107', 'SAURAMA', '0511', '05'), ('051108', 'VISCHONGO', '0511', '05'), ('060000', 'CAJAMARCA', '0600', '06'), ('060100', 'CAJAMARCA', '0601', '06'), ('060101', 'CAJAMARCA', '0601', '06'), ('060102', 'ASUNCION', '0601', '06'), ('060103', 'CHETILLA', '0601', '06'), ('060104', 'COSPAN', '0601', '06'), ('060105', 'ENCAÑADA', '0601', '06'), ('060106', 'JESUS', '0601', '06'), ('060107', 'LLACANORA', '0601', '06'), ('060108', 'LOS BAÑOS DEL INCA', '0601', '06'), ('060109', 'MAGDALENA', '0601', '06'), ('060110', 'MATARA', '0601', '06'), ('060111', 'NAMORA', '0601', '06'), ('060112', 'SAN JUAN', '0601', '06'), ('060200', 'CAJABAMBA', '0602', '06'), ('060201', 'CAJABAMBA', '0602', '06'), ('060202', 'CACHACHI', '0602', '06'), ('060203', 'CONDEBAMBA', '0602', '06'), ('060204', 'SITACOCHA', '0602', '06'), ('060300', 'CELENDIN', '0603', '06'), ('060301', 'CELENDIN', '0603', '06'), ('060302', 'CHUMUCH', '0603', '06'), ('060303', 'CORTEGANA', '0603', '06'), ('060304', 'HUASMIN', '0603', '06'), ('060305', 'JORGE CHAVEZ', '0603', '06'), ('060306', 'JOSE GALVEZ', '0603', '06'), ('060307', 'MIGUEL IGLESIAS', '0603', '06'), ('060308', 'OXAMARCA', '0603', '06'), ('060309', 'SOROCHUCO', '0603', '06'), ('060310', 'SUCRE', '0603', '06'), ('060311', 'UTCO', '0603', '06'), ('060312', 'LA LIBERTAD DE PALLAN', '0603', '06'), ('060400', 'CHOTA', '0604', '06'), ('060401', 'CHOTA', '0604', '06'), ('060402', 'ANGUIA', '0604', '06'), ('060403', 'CHADIN', '0604', '06'), ('060404', 'CHIGUIRIP', '0604', '06'), ('060405', 'CHIMBAN', '0604', '06'), ('060406', 'CHOROPAMPA', '0604', '06'), ('060407', 'COCHABAMBA', '0604', '06'), ('060408', 'CONCHAN', '0604', '06'), ('060409', 'HUAMBOS', '0604', '06'), ('060410', 'LAJAS', '0604', '06'), ('060411', 'LLAMA', '0604', '06'), ('060412', 'MIRACOSTA', '0604', '06'), ('060413', 'PACCHA', '0604', '06'), ('060414', 'PION', '0604', '06'), ('060415', 'QUEROCOTO', '0604', '06'), ('060416', 'SAN JUAN DE LICUPIS', '0604', '06'), ('060417', 'TACABAMBA', '0604', '06'), ('060418', 'TOCMOCHE', '0604', '06'), ('060419', 'CHALAMARCA', '0604', '06'), ('060500', 'CONTUMAZA', '0605', '06'), ('060501', 'CONTUMAZA', '0605', '06'), ('060502', 'CHILETE', '0605', '06'), ('060503', 'CUPISNIQUE', '0605', '06'), ('060504', 'GUZMANGO', '0605', '06'), ('060505', 'SAN BENITO', '0605', '06'), ('060506', 'SANTA CRUZ DE TOLED', '0605', '06'), ('060507', 'TANTARICA', '0605', '06'), ('060508', 'YONAN', '0605', '06'), ('060600', 'CUTERVO', '0606', '06'), ('060601', 'CUTERVO', '0606', '06'), ('060602', 'CALLAYUC', '0606', '06'), ('060603', 'CHOROS', '0606', '06'), ('060604', 'CUJILLO', '0606', '06'), ('060605', 'LA RAMADA', '0606', '06'), ('060606', 'PIMPINGOS', '0606', '06'), ('060607', 'QUEROCOTILLO', '0606', '06'), ('060608', 'SAN ANDRES DE CUTERVO', '0606', '06'), ('060609', 'SAN JUAN DE CUTERVO', '0606', '06'), ('060610', 'SAN LUIS DE LUCMA', '0606', '06'), ('060611', 'SANTA CRUZ', '0606', '06'), ('060612', 'SANTO DOMINGO DE LA CAPILLA', '0606', '06'), ('060613', 'SANTO TOMAS', '0606', '06'), ('060614', 'SOCOTA', '0606', '06'), ('060615', 'TORIBIO CASANOVA', '0606', '06'), ('060700', 'HUALGAYOC', '0607', '06'), ('060701', 'BAMBAMARCA', '0607', '06'), ('060702', 'CHUGUR', '0607', '06'), ('060703', 'HUALGAYOC', '0607', '06'), ('060800', 'JAEN', '0608', '06'), ('060801', 'JAEN', '0608', '06'), ('060802', 'BELLAVISTA', '0608', '06'), ('060803', 'CHONTALI', '0608', '06'), ('060804', 'COLASAY', '0608', '06'), ('060805', 'HUABAL', '0608', '06'), ('060806', 'LAS PIRIAS', '0608', '06'), ('060807', 'POMAHUACA', '0608', '06'), ('060808', 'PUCARA', '0608', '06'), ('060809', 'SALLIQUE', '0608', '06'), ('060810', 'SAN FELIPE', '0608', '06'), ('060811', 'SAN JOSE DEL ALTO', '0608', '06'), ('060812', 'SANTA ROSA', '0608', '06'), ('060900', 'SAN IGNACIO', '0609', '06'), ('060901', 'SAN IGNACIO', '0609', '06'), ('060902', 'CHIRINOS', '0609', '06'), ('060903', 'HUARANGO', '0609', '06'), ('060904', 'LA COIPA', '0609', '06');
INSERT INTO `tb_distrito` VALUES ('060905', 'NAMBALLE', '0609', '06'), ('060906', 'SAN JOSE DE LOURDES', '0609', '06'), ('060907', 'TABACONAS', '0609', '06'), ('061000', 'SAN MARCOS', '0610', '06'), ('061001', 'PEDRO GALVEZ', '0610', '06'), ('061002', 'CHANCAY', '0610', '06'), ('061003', 'EDUARDO VILLANUEVA', '0610', '06'), ('061004', 'GREGORIO PITA', '0610', '06'), ('061005', 'ICHOCAN', '0610', '06'), ('061006', 'JOSE MANUEL QUIROZ', '0610', '06'), ('061007', 'JOSE SABOGAL', '0610', '06'), ('061100', 'SAN MIGUEL', '0611', '06'), ('061101', 'SAN MIGUEL', '0611', '06'), ('061102', 'BOLIVAR', '0611', '06'), ('061103', 'CALQUIS', '0611', '06'), ('061104', 'CATILLUC', '0611', '06'), ('061105', 'EL PRADO', '0611', '06'), ('061106', 'LA FLORIDA', '0611', '06'), ('061107', 'LLAPA', '0611', '06'), ('061108', 'NANCHOC', '0611', '06'), ('061109', 'NIEPOS', '0611', '06'), ('061110', 'SAN GREGORIO', '0611', '06'), ('061111', 'SAN SILVESTRE DE COCHAN', '0611', '06'), ('061112', 'TONGOD', '0611', '06'), ('061113', 'UNION AGUA BLANCA', '0611', '06'), ('061200', 'SAN PABLO', '0612', '06'), ('061201', 'SAN PABLO', '0612', '06'), ('061202', 'SAN BERNARDINO', '0612', '06'), ('061203', 'SAN LUIS', '0612', '06'), ('061204', 'TUMBADEN', '0612', '06'), ('061300', 'SANTA CRUZ', '0613', '06'), ('061301', 'SANTA CRUZ', '0613', '06'), ('061302', 'ANDABAMBA', '0613', '06'), ('061303', 'CATACHE', '0613', '06'), ('061304', 'CHANCAYBAÑOS', '0613', '06'), ('061305', 'LA ESPERANZA', '0613', '06'), ('061306', 'NINABAMBA', '0613', '06'), ('061307', 'PULAN', '0613', '06'), ('061308', 'SAUCEPAMPA', '0613', '06'), ('061309', 'SEXI', '0613', '06'), ('061310', 'UTICYACU', '0613', '06'), ('061311', 'YAUYUCAN', '0613', '06'), ('070000', 'CALLAO', '0700', '07'), ('070100', 'CALLAO', '0701', '07'), ('070101', 'CALLAO', '0701', '07'), ('070102', 'BELLAVISTA', '0701', '07'), ('070103', 'CARMEN DE LA LEGUA REYNOSO', '0701', '07'), ('070104', 'LA PERLA', '0701', '07'), ('070105', 'LA PUNTA', '0701', '07'), ('070106', 'VENTANILLA', '0701', '07'), ('080000', 'CUSCO', '0800', '08'), ('080100', 'CUSCO', '0801', '08'), ('080101', 'CUSCO', '0801', '08'), ('080102', 'CCORCA', '0801', '08'), ('080103', 'POROY', '0801', '08'), ('080104', 'SAN JERONIMO', '0801', '08'), ('080105', 'SAN SEBASTIAN', '0801', '08'), ('080106', 'SANTIAGO', '0801', '08'), ('080107', 'SAYLLA', '0801', '08'), ('080108', 'WANCHAQ', '0801', '08'), ('080200', 'ACOMAYO', '0802', '08'), ('080201', 'ACOMAYO', '0802', '08'), ('080202', 'ACOPIA', '0802', '08'), ('080203', 'ACOS', '0802', '08'), ('080204', 'MOSOC LLACTA', '0802', '08'), ('080205', 'POMACANCHI', '0802', '08'), ('080206', 'RONDOCAN', '0802', '08'), ('080207', 'SANGARARA', '0802', '08'), ('080300', 'ANTA', '0803', '08'), ('080301', 'ANTA', '0803', '08'), ('080302', 'ANCAHUASI', '0803', '08'), ('080303', 'CACHIMAYO', '0803', '08'), ('080304', 'CHINCHAYPUJIO', '0803', '08'), ('080305', 'HUAROCONDO', '0803', '08'), ('080306', 'LIMATAMBO', '0803', '08'), ('080307', 'MOLLEPATA', '0803', '08'), ('080308', 'PUCYURA', '0803', '08'), ('080309', 'ZURITE', '0803', '08'), ('080400', 'CALCA', '0804', '08'), ('080401', 'CALCA', '0804', '08'), ('080402', 'COYA', '0804', '08'), ('080403', 'LAMAY', '0804', '08'), ('080404', 'LARES', '0804', '08'), ('080405', 'PISAC', '0804', '08'), ('080406', 'SAN SALVADOR', '0804', '08'), ('080407', 'TARAY', '0804', '08'), ('080408', 'YANATILE', '0804', '08'), ('080500', 'CANAS', '0805', '08'), ('080501', 'YANAOCA', '0805', '08'), ('080502', 'CHECCA', '0805', '08'), ('080503', 'KUNTURKANKI', '0805', '08'), ('080504', 'LANGUI', '0805', '08'), ('080505', 'LAYO', '0805', '08'), ('080506', 'PAMPAMARCA', '0805', '08'), ('080507', 'QUEHUE', '0805', '08'), ('080508', 'TUPAC AMARU', '0805', '08'), ('080600', 'CANCHIS', '0806', '08'), ('080601', 'SICUANI', '0806', '08'), ('080602', 'CHECACUPE', '0806', '08'), ('080603', 'COMBAPATA', '0806', '08'), ('080604', 'MARANGANI', '0806', '08');
INSERT INTO `tb_distrito` VALUES ('080605', 'PITUMARCA', '0806', '08'), ('080606', 'SAN PABLO', '0806', '08'), ('080607', 'SAN PEDRO', '0806', '08'), ('080608', 'TINTA', '0806', '08'), ('080700', 'CHUMBIVILCAS', '0807', '08'), ('080701', 'SANTO TOMAS', '0807', '08'), ('080702', 'CAPACMARCA', '0807', '08'), ('080703', 'CHAMACA', '0807', '08'), ('080704', 'COLQUEMARCA', '0807', '08'), ('080705', 'LIVITACA', '0807', '08'), ('080706', 'LLUSCO', '0807', '08'), ('080707', 'QUIÑOTA', '0807', '08'), ('080708', 'VELILLE', '0807', '08'), ('080800', 'ESPINAR', '0808', '08'), ('080801', 'ESPINAR', '0808', '08'), ('080802', 'CONDOROMA', '0808', '08'), ('080803', 'COPORAQUE', '0808', '08'), ('080804', 'OCORURO', '0808', '08'), ('080805', 'PALLPATA', '0808', '08'), ('080806', 'PICHIGUA', '0808', '08'), ('080807', 'SUYCKUTAMBO', '0808', '08'), ('080808', 'ALTO PICHIGUA', '0808', '08'), ('080900', 'LA CONVENCION', '0809', '08'), ('080901', 'SANTA ANA', '0809', '08'), ('080902', 'ECHARATE', '0809', '08'), ('080903', 'HUAYOPATA', '0809', '08'), ('080904', 'MARANURA', '0809', '08'), ('080905', 'OCOBAMBA', '0809', '08'), ('080906', 'QUELLOUNO', '0809', '08'), ('080907', 'QUIMBIRI', '0809', '08'), ('080908', 'SANTA TERESA', '0809', '08'), ('080909', 'VILCABAMBA', '0809', '08'), ('080910', 'PICHARI', '0809', '08'), ('081000', 'PARURO', '0810', '08'), ('081001', 'PARURO', '0810', '08'), ('081002', 'ACCHA', '0810', '08'), ('081003', 'CCAPI', '0810', '08'), ('081004', 'COLCHA', '0810', '08'), ('081005', 'HUANOQUITE', '0810', '08'), ('081006', 'OMACHA', '0810', '08'), ('081007', 'PACCARITAMBO', '0810', '08'), ('081008', 'PILLPINTO', '0810', '08'), ('081009', 'YAURISQUE', '0810', '08'), ('081100', 'PAUCARTAMBO', '0811', '08'), ('081101', 'PAUCARTAMBO', '0811', '08'), ('081102', 'CAICAY', '0811', '08'), ('081103', 'CHALLABAMBA', '0811', '08'), ('081104', 'COLQUEPATA', '0811', '08'), ('081105', 'HUANCARANI', '0811', '08'), ('081106', 'KOSÑIPATA', '0811', '08'), ('081200', 'QUISPICANCHI', '0812', '08'), ('081201', 'URCOS', '0812', '08'), ('081202', 'ANDAHUAYLILLAS', '0812', '08'), ('081203', 'CAMANTI', '0812', '08'), ('081204', 'CCARHUAYO', '0812', '08'), ('081205', 'CCATCA', '0812', '08'), ('081206', 'CUSIPATA', '0812', '08'), ('081207', 'HUARO', '0812', '08'), ('081208', 'LUCRE', '0812', '08'), ('081209', 'MARCAPATA', '0812', '08'), ('081210', 'OCONGATE', '0812', '08'), ('081211', 'OROPESA', '0812', '08'), ('081212', 'QUIQUIJANA', '0812', '08'), ('081300', 'URUBAMBA', '0813', '08'), ('081301', 'URUBAMBA', '0813', '08'), ('081302', 'CHINCHERO', '0813', '08'), ('081303', 'HUAYLLABAMBA', '0813', '08'), ('081304', 'MACHUPICCHU', '0813', '08'), ('081305', 'MARAS', '0813', '08'), ('081306', 'OLLANTAYTAMBO', '0813', '08'), ('081307', 'YUCAY', '0813', '08'), ('090000', 'HUANCAVELICA', '0900', '09'), ('090100', 'HUANCAVELICA', '0901', '09'), ('090101', 'HUANCAVELICA', '0901', '09'), ('090102', 'ACOBAMBILLA', '0901', '09'), ('090103', 'ACORIA', '0901', '09'), ('090104', 'CONAYCA', '0901', '09'), ('090105', 'CUENCA', '0901', '09'), ('090106', 'HUACHOCOLPA', '0901', '09'), ('090107', 'HUAYLLAHUARA', '0901', '09'), ('090108', 'IZCUCHACA', '0901', '09'), ('090109', 'LARIA', '0901', '09'), ('090110', 'MANTA', '0901', '09'), ('090111', 'MARISCAL CACERES', '0901', '09'), ('090112', 'MOYA', '0901', '09'), ('090113', 'NUEVO OCCORO', '0901', '09'), ('090114', 'PALCA', '0901', '09'), ('090115', 'PILCHACA', '0901', '09'), ('090116', 'VILCA', '0901', '09'), ('090117', 'YAULI', '0901', '09'), ('090118', 'ASCENSION', '0901', '09'), ('090119', 'HUANDO', '0901', '09'), ('090200', 'ACOBAMBA', '0902', '09'), ('090201', 'ACOBAMBA', '0902', '09'), ('090202', 'ANDABAMBA', '0902', '09'), ('090203', 'ANTA', '0902', '09'), ('090204', 'CAJA', '0902', '09'), ('090205', 'MARCAS', '0902', '09'), ('090206', 'PAUCARA', '0902', '09'), ('090207', 'POMACOCHA', '0902', '09'), ('090208', 'ROSARIO', '0902', '09');
INSERT INTO `tb_distrito` VALUES ('090300', 'ANGARAES', '0903', '09'), ('090301', 'LIRCAY', '0903', '09'), ('090302', 'ANCHONGA', '0903', '09'), ('090303', 'CALLANMARCA', '0903', '09'), ('090304', 'CCOCHACCASA', '0903', '09'), ('090305', 'CHINCHO', '0903', '09'), ('090306', 'CONGALLA', '0903', '09'), ('090307', 'HUANCA-HUANCA', '0903', '09'), ('090308', 'HUAYLLAY GRANDE', '0903', '09'), ('090309', 'JULCAMARCA', '0903', '09'), ('090310', 'SAN ANTONIO DE ANTAPARCO', '0903', '09'), ('090311', 'SANTO TOMAS DE PATA', '0903', '09'), ('090312', 'SECCLLA', '0903', '09'), ('090400', 'CASTROVIRREYNA', '0904', '09'), ('090401', 'CASTROVIRREYNA', '0904', '09'), ('090402', 'ARMA', '0904', '09'), ('090403', 'AURAHUA', '0904', '09'), ('090404', 'CAPILLAS', '0904', '09'), ('090405', 'CHUPAMARCA', '0904', '09'), ('090406', 'COCAS', '0904', '09'), ('090407', 'HUACHOS', '0904', '09'), ('090408', 'HUAMATAMBO', '0904', '09'), ('090409', 'MOLLEPAMPA', '0904', '09'), ('090410', 'SAN JUAN', '0904', '09'), ('090411', 'SANTA ANA', '0904', '09'), ('090412', 'TANTARA', '0904', '09'), ('090413', 'TICRAPO', '0904', '09'), ('090500', 'CHURCAMPA', '0905', '09'), ('090501', 'CHURCAMPA', '0905', '09'), ('090502', 'ANCO', '0905', '09'), ('090503', 'CHINCHIHUASI', '0905', '09'), ('090504', 'EL CARMEN', '0905', '09'), ('090505', 'LA MERCED', '0905', '09'), ('090506', 'LOCROJA', '0905', '09'), ('090507', 'PAUCARBAMBA', '0905', '09'), ('090508', 'SAN MIGUEL DE MAYOCC', '0905', '09'), ('090509', 'SAN PEDRO DE CORIS', '0905', '09'), ('090510', 'PACHAMARCA', '0905', '09'), ('090600', 'HUAYTARA', '0906', '09'), ('090601', 'HUAYTARA', '0906', '09'), ('090602', 'AYAVI', '0906', '09'), ('090603', 'CORDOVA', '0906', '09'), ('090604', 'HUAYACUNDO ARMA', '0906', '09'), ('090605', 'LARAMARCA', '0906', '09'), ('090606', 'OCOYO', '0906', '09'), ('090607', 'PILPICHACA', '0906', '09'), ('090608', 'QUERCO', '0906', '09'), ('090609', 'QUITO-ARMA', '0906', '09'), ('090610', 'SAN ANTONIO DE CUSICANCHA', '0906', '09'), ('090611', 'SAN FRANCISCO DE SANGAYAICO', '0906', '09'), ('090612', 'SAN ISIDRO', '0906', '09'), ('090613', 'SANTIAGO DE CHOCORVOS', '0906', '09'), ('090614', 'SANTIAGO DE QUIRAHUARA', '0906', '09'), ('090615', 'SANTO DOMINGO DE CAPILLAS', '0906', '09'), ('090616', 'TAMBO', '0906', '09'), ('090700', 'TAYACAJA', '0907', '09'), ('090701', 'PAMPAS', '0907', '09'), ('090702', 'ACOSTAMBO', '0907', '09'), ('090703', 'ACRAQUIA', '0907', '09'), ('090704', 'AHUAYCHA', '0907', '09'), ('090705', 'COLCABAMBA', '0907', '09'), ('090706', 'DANIEL HERNANDEZ', '0907', '09'), ('090707', 'HUACHOCOLPA', '0907', '09'), ('090709', 'HUARIBAMBA', '0907', '09'), ('090710', 'ÑAHUIMPUQUIO', '0907', '09'), ('090711', 'PAZOS', '0907', '09'), ('090713', 'QUISHUAR', '0907', '09'), ('090714', 'SALCABAMBA', '0907', '09'), ('090715', 'SALCAHUASI', '0907', '09'), ('090716', 'SAN MARCOS DE ROCCHAC', '0907', '09'), ('090717', 'SURCUBAMBA', '0907', '09'), ('090718', 'TINTAY PUNCU', '0907', '09'), ('100000', 'HUANUCO', '1000', '10'), ('100100', 'HUANUCO', '1001', '10'), ('100101', 'HUANUCO', '1001', '10'), ('100102', 'AMARILIS', '1001', '10'), ('100103', 'CHINCHAO', '1001', '10'), ('100104', 'CHURUBAMBA', '1001', '10'), ('100105', 'MARGOS', '1001', '10'), ('100106', 'QUISQUI', '1001', '10'), ('100107', 'SAN FRANCISCO DE CAYRAN', '1001', '10'), ('100108', 'SAN PEDRO DE CHAULAN', '1001', '10'), ('100109', 'SANTA MARIA DEL VALLE', '1001', '10'), ('100110', 'YARUMAYO', '1001', '10'), ('100111', 'PILLCO MARCA', '1001', '10'), ('100200', 'AMBO', '1002', '10'), ('100201', 'AMBO', '1002', '10'), ('100202', 'CAYNA', '1002', '10'), ('100203', 'COLPAS', '1002', '10'), ('100204', 'CONCHAMARCA', '1002', '10'), ('100205', 'HUACAR', '1002', '10'), ('100206', 'SAN FRANCISCO', '1002', '10'), ('100207', 'SAN RAFAEL', '1002', '10'), ('100208', 'TOMAY KICHWA', '1002', '10'), ('100300', 'DOS DE MAYO', '1003', '10'), ('100301', 'LA UNION', '1003', '10'), ('100307', 'CHUQUIS', '1003', '10'), ('100311', 'MARIAS', '1003', '10'), ('100313', 'PACHAS', '1003', '10'), ('100316', 'QUIVILLA', '1003', '10'), ('100317', 'RIPAN', '1003', '10');
INSERT INTO `tb_distrito` VALUES ('100321', 'SHUNQUI', '1003', '10'), ('100322', 'SILLAPATA', '1003', '10'), ('100323', 'YANAS', '1003', '10'), ('100400', 'HUACAYBAMBA', '1004', '10'), ('100401', 'HUACAYBAMBA', '1004', '10'), ('100402', 'CANCHABAMBA', '1004', '10'), ('100403', 'COCHABAMBA', '1004', '10'), ('100404', 'PINRA', '1004', '10'), ('100500', 'HUAMALIES', '1005', '10'), ('100501', 'LLATA', '1005', '10'), ('100502', 'ARANCAY', '1005', '10'), ('100503', 'CHAVIN DE PARIARCA', '1005', '10'), ('100504', 'JACAS GRANDE', '1005', '10'), ('100505', 'JIRCAN', '1005', '10'), ('100506', 'MIRAFLORES', '1005', '10'), ('100507', 'MONZON', '1005', '10'), ('100508', 'PUNCHAO', '1005', '10'), ('100509', 'PUÑOS', '1005', '10'), ('100510', 'SINGA', '1005', '10'), ('100511', 'TANTAMAYO', '1005', '10'), ('100600', 'LEONCIO PRADO', '1006', '10'), ('100601', 'RUPA-RUPA', '1006', '10'), ('100602', 'DANIEL ALOMIAS ROBLES', '1006', '10'), ('100603', 'HERMILIO VALDIZAN', '1006', '10'), ('100604', 'JOSE CRESPO Y CASTILLO', '1006', '10'), ('100605', 'LUYANDO', '1006', '10'), ('100606', 'MARIANO DAMASO BERAUN', '1006', '10'), ('100700', 'MARAÑON', '1007', '10'), ('100701', 'HUACRACHUCO', '1007', '10'), ('100702', 'CHOLON', '1007', '10'), ('100703', 'SAN BUENAVENTURA', '1007', '10'), ('100800', 'PACHITEA', '1008', '10'), ('100801', 'PANAO', '1008', '10'), ('100802', 'CHAGLLA', '1008', '10'), ('100803', 'MOLINO', '1008', '10'), ('100804', 'UMARI', '1008', '10'), ('100900', 'PUERTO INCA', '1009', '10'), ('100901', 'PUERTO INCA', '1009', '10'), ('100902', 'CODO DEL POZUZO', '1009', '10'), ('100903', 'HONORIA', '1009', '10'), ('100904', 'TOURNAVISTA', '1009', '10'), ('100905', 'YUYAPICHIS', '1009', '10'), ('101000', 'LAURICOCHA', '1010', '10'), ('101001', 'JESUS', '1010', '10'), ('101002', 'BAÑOS', '1010', '10'), ('101003', 'JIVIA', '1010', '10'), ('101004', 'QUEROPALCA', '1010', '10'), ('101005', 'RONDOS', '1010', '10'), ('101006', 'SAN FRANCISCO DE ASIS', '1010', '10'), ('101007', 'SAN MIGUEL DE CAURI', '1010', '10'), ('101100', 'YAROWILCA', '1011', '10'), ('101101', 'CHAVINILLO', '1011', '10'), ('101102', 'CAHUAC', '1011', '10'), ('101103', 'CHACABAMBA', '1011', '10'), ('101104', 'CHUPAN', '1011', '10'), ('101105', 'JACAS CHICO', '1011', '10'), ('101106', 'OBAS', '1011', '10'), ('101107', 'PAMPAMARCA', '1011', '10'), ('101108', 'CHORAS', '1011', '10'), ('110000', 'ICA', '1100', '11'), ('110100', 'ICA', '1101', '11'), ('110101', 'ICA', '1101', '11'), ('110102', 'LA TINGUIÑA', '1101', '11'), ('110103', 'LOS AQUIJES', '1101', '11'), ('110104', 'OCUCAJE', '1101', '11'), ('110105', 'PACHACUTEC', '1101', '11'), ('110106', 'PARCONA', '1101', '11'), ('110107', 'PUEBLO NUEVO', '1101', '11'), ('110108', 'SALAS', '1101', '11'), ('110109', 'SAN JOSE DE LOS MOLINOS', '1101', '11'), ('110110', 'SAN JUAN BAUTISTA', '1101', '11'), ('110111', 'SANTIAGO', '1101', '11'), ('110112', 'SUBTANJALLA', '1101', '11'), ('110113', 'TATE', '1101', '11'), ('110114', 'YAUCA DEL ROSARIO', '1101', '11'), ('110200', 'CHINCHA', '1102', '11'), ('110201', 'CHINCHA ALTA', '1102', '11'), ('110202', 'ALTO LARAN', '1102', '11'), ('110203', 'CHAVIN', '1102', '11'), ('110204', 'CHINCHA BAJA', '1102', '11'), ('110205', 'EL CARMEN', '1102', '11'), ('110206', 'GROCIO PRADO', '1102', '11'), ('110207', 'PUEBLO NUEVO', '1102', '11'), ('110208', 'SAN JUAN DE YANAC', '1102', '11'), ('110209', 'SAN PEDRO DE HUACARPANA', '1102', '11'), ('110210', 'SUNAMPE', '1102', '11'), ('110211', 'TAMBO DE MORA', '1102', '11'), ('110300', 'NAZCA', '1103', '11'), ('110301', 'NAZCA', '1103', '11'), ('110302', 'CHANGUILLO', '1103', '11'), ('110303', 'EL INGENIO', '1103', '11'), ('110304', 'MARCONA', '1103', '11'), ('110305', 'VISTA ALEGRE', '1103', '11'), ('110400', 'PALPA', '1104', '11'), ('110401', 'PALPA', '1104', '11'), ('110402', 'LLIPATA', '1104', '11'), ('110403', 'RIO GRANDE', '1104', '11'), ('110404', 'SANTA CRUZ', '1104', '11'), ('110405', 'TIBILLO', '1104', '11'), ('110500', 'PISCO', '1105', '11'), ('110501', 'PISCO', '1105', '11');
INSERT INTO `tb_distrito` VALUES ('110502', 'HUANCANO', '1105', '11'), ('110503', 'HUMAY', '1105', '11'), ('110504', 'INDEPENDENCIA', '1105', '11'), ('110505', 'PARACAS', '1105', '11'), ('110506', 'SAN ANDRES', '1105', '11'), ('110507', 'SAN CLEMENTE', '1105', '11'), ('110508', 'TUPAC AMARU INCA', '1105', '11'), ('120000', 'JUNIN', '1200', '12'), ('120100', 'HUANCAYO', '1201', '12'), ('120101', 'HUANCAYO', '1201', '12'), ('120104', 'CARHUACALLANGA', '1201', '12'), ('120105', 'CHACAPAMPA', '1201', '12'), ('120106', 'CHICCHE', '1201', '12'), ('120107', 'CHILCA', '1201', '12'), ('120108', 'CHONGOS ALTO', '1201', '12'), ('120111', 'CHUPURO', '1201', '12'), ('120112', 'COLCA', '1201', '12'), ('120113', 'CULLHUAS', '1201', '12'), ('120114', 'EL TAMBO', '1201', '12'), ('120116', 'HUACRAPUQUIO', '1201', '12'), ('120117', 'HUALHUAS', '1201', '12'), ('120119', 'HUANCAN', '1201', '12'), ('120120', 'HUASICANCHA', '1201', '12'), ('120121', 'HUAYUCACHI', '1201', '12'), ('120122', 'INGENIO', '1201', '12'), ('120124', 'PARIAHUANCA', '1201', '12'), ('120125', 'PILCOMAYO', '1201', '12'), ('120126', 'PUCARA', '1201', '12'), ('120127', 'QUICHUAY', '1201', '12'), ('120128', 'QUILCAS', '1201', '12'), ('120129', 'SAN AGUSTIN', '1201', '12'), ('120130', 'SAN JERONIMO DE TUNAN', '1201', '12'), ('120132', 'SAÑO', '1201', '12'), ('120133', 'SAPALLANGA', '1201', '12'), ('120134', 'SICAYA', '1201', '12'), ('120135', 'SANTO DOMINGO DE ACOBAMBA', '1201', '12'), ('120136', 'VIQUES', '1201', '12'), ('120200', 'CONCEPCION', '1202', '12'), ('120201', 'CONCEPCION', '1202', '12'), ('120202', 'ACO', '1202', '12'), ('120203', 'ANDAMARCA', '1202', '12'), ('120204', 'CHAMBARA', '1202', '12'), ('120205', 'COCHAS', '1202', '12'), ('120206', 'COMAS', '1202', '12'), ('120207', 'HEROINAS TOLEDO', '1202', '12'), ('120208', 'MANZANARES', '1202', '12'), ('120209', 'MARISCAL CASTILLA', '1202', '12'), ('120210', 'MATAHUASI', '1202', '12'), ('120211', 'MITO', '1202', '12'), ('120212', 'NUEVE DE JULIO', '1202', '12'), ('120213', 'ORCOTUNA', '1202', '12'), ('120214', 'SAN JOSE DE QUERO', '1202', '12'), ('120215', 'SANTA ROSA DE OCOPA', '1202', '12'), ('120300', 'CHANCHAMAYO', '1203', '12'), ('120301', 'CHANCHAMAYO', '1203', '12'), ('120302', 'PERENE', '1203', '12'), ('120303', 'PICHANAQUI', '1203', '12'), ('120304', 'SAN LUIS DE SHUARO', '1203', '12'), ('120305', 'SAN RAMON', '1203', '12'), ('120306', 'VITOC', '1203', '12'), ('120400', 'JAUJA', '1204', '12'), ('120401', 'JAUJA', '1204', '12'), ('120402', 'ACOLLA', '1204', '12'), ('120403', 'APATA', '1204', '12'), ('120404', 'ATAURA', '1204', '12'), ('120405', 'CANCHAYLLO', '1204', '12'), ('120406', 'CURICACA', '1204', '12'), ('120407', 'EL MANTARO', '1204', '12'), ('120408', 'HUAMALI', '1204', '12'), ('120409', 'HUARIPAMPA', '1204', '12'), ('120410', 'HUERTAS', '1204', '12'), ('120411', 'JANJAILLO', '1204', '12'), ('120412', 'JULCAN', '1204', '12'), ('120413', 'LEONOR ORDOÑEZ', '1204', '12'), ('120414', 'LLOCLLAPAMPA', '1204', '12'), ('120415', 'MARCO', '1204', '12'), ('120416', 'MASMA', '1204', '12'), ('120417', 'MASMA CHICCHE', '1204', '12'), ('120418', 'MOLINOS', '1204', '12'), ('120419', 'MONOBAMBA', '1204', '12'), ('120420', 'MUQUI', '1204', '12'), ('120421', 'MUQUIYAUYO', '1204', '12'), ('120422', 'PACA', '1204', '12'), ('120423', 'PACCHA', '1204', '12'), ('120424', 'PANCAN', '1204', '12'), ('120425', 'PARCO', '1204', '12'), ('120426', 'POMACANCHA', '1204', '12'), ('120427', 'RICRAN', '1204', '12'), ('120428', 'SAN LORENZO', '1204', '12'), ('120429', 'SAN PEDRO DE CHUNAN', '1204', '12'), ('120430', 'SAUSA', '1204', '12'), ('120431', 'SINCOS', '1204', '12'), ('120432', 'TUNAN MARCA', '1204', '12'), ('120433', 'YAULI', '1204', '12'), ('120434', 'YAUYOS', '1204', '12'), ('120500', 'JUNIN', '1205', '12'), ('120501', 'JUNIN', '1205', '12'), ('120502', 'CARHUAMAYO', '1205', '12'), ('120503', 'ONDORES', '1205', '12'), ('120504', 'ULCUMAYO', '1205', '12'), ('120600', 'SATIPO', '1206', '12');
INSERT INTO `tb_distrito` VALUES ('120601', 'SATIPO', '1206', '12'), ('120602', 'COVIRIALI', '1206', '12'), ('120603', 'LLAYLLA', '1206', '12'), ('120604', 'MAZAMARI', '1206', '12'), ('120605', 'PAMPA HERMOSA', '1206', '12'), ('120606', 'PANGOA', '1206', '12'), ('120607', 'RIO NEGRO', '1206', '12'), ('120608', 'RIO TAMBO', '1206', '12'), ('120700', 'TARMA', '1207', '12'), ('120701', 'TARMA', '1207', '12'), ('120702', 'ACOBAMBA', '1207', '12'), ('120703', 'HUARICOLCA', '1207', '12'), ('120704', 'HUASAHUASI', '1207', '12'), ('120705', 'LA UNION', '1207', '12'), ('120706', 'PALCA', '1207', '12'), ('120707', 'PALCAMAYO', '1207', '12'), ('120708', 'SAN PEDRO DE CAJAS', '1207', '12'), ('120709', 'TAPO', '1207', '12'), ('120800', 'YAULI', '1208', '12'), ('120801', 'LA OROYA', '1208', '12'), ('120802', 'CHACAPALPA', '1208', '12'), ('120803', 'HUAY-HUAY', '1208', '12'), ('120804', 'MARCAPOMACOCHA', '1208', '12'), ('120805', 'MOROCOCHA', '1208', '12'), ('120806', 'PACCHA', '1208', '12'), ('120807', 'SANTA BARBARA DE CARHUACAYAN', '1208', '12'), ('120808', 'SANTA ROSA DE SACCO', '1208', '12'), ('120809', 'SUITUCANCHA', '1208', '12'), ('120810', 'YAULI', '1208', '12'), ('120900', 'CHUPACA', '1209', '12'), ('120901', 'CHUPACA', '1209', '12'), ('120902', 'AHUAC', '1209', '12'), ('120903', 'CHONGOS BAJO', '1209', '12'), ('120904', 'HUACHAC', '1209', '12'), ('120905', 'HUAMANCACA CHICO', '1209', '12'), ('120906', 'SAN JUAN DE ISCOS', '1209', '12'), ('120907', 'SAN JUAN DE JARPA', '1209', '12'), ('120908', '3 DE DICIEMBRE', '1209', '12'), ('120909', 'YANACANCHA', '1209', '12'), ('130000', 'LA LIBERTAD', '1300', '13'), ('130100', 'TRUJILLO', '1301', '13'), ('130101', 'TRUJILLO', '1301', '13'), ('130102', 'EL PORVENIR', '1301', '13'), ('130103', 'FLORENCIA DE MORA', '1301', '13'), ('130104', 'HUANCHACO', '1301', '13'), ('130105', 'LA ESPERANZA', '1301', '13'), ('130106', 'LAREDO', '1301', '13'), ('130107', 'MOCHE', '1301', '13'), ('130108', 'POROTO', '1301', '13'), ('130109', 'SALAVERRY', '1301', '13'), ('130110', 'SIMBAL', '1301', '13'), ('130111', 'VICTOR LARCO HERRERA', '1301', '13'), ('130200', 'ASCOPE', '1302', '13'), ('130201', 'ASCOPE', '1302', '13'), ('130202', 'CHICAMA', '1302', '13'), ('130203', 'CHOCOPE', '1302', '13'), ('130204', 'MAGDALENA DE CAO', '1302', '13'), ('130205', 'PAIJAN', '1302', '13'), ('130206', 'RAZURI', '1302', '13'), ('130207', 'SANTIAGO DE CAO', '1302', '13'), ('130208', 'CASA GRANDE', '1302', '13'), ('130300', 'BOLIVAR', '1303', '13'), ('130301', 'BOLIVAR', '1303', '13'), ('130302', 'BAMBAMARCA', '1303', '13'), ('130303', 'CONDORMARCA', '1303', '13'), ('130304', 'LONGOTEA', '1303', '13'), ('130305', 'UCHUMARCA', '1303', '13'), ('130306', 'UCUNCHA', '1303', '13'), ('130400', 'CHEPEN', '1304', '13'), ('130401', 'CHEPEN', '1304', '13'), ('130402', 'PACANGA', '1304', '13'), ('130403', 'PUEBLO NUEVO', '1304', '13'), ('130500', 'JULCAN', '1305', '13'), ('130501', 'JULCAN', '1305', '13'), ('130502', 'CALAMARCA', '1305', '13'), ('130503', 'CARABAMBA', '1305', '13'), ('130504', 'HUASO', '1305', '13'), ('130600', 'OTUZCO', '1306', '13'), ('130601', 'OTUZCO', '1306', '13'), ('130602', 'AGALLPAMPA', '1306', '13'), ('130604', 'CHARAT', '1306', '13'), ('130605', 'HUARANCHAL', '1306', '13'), ('130606', 'LA CUESTA', '1306', '13'), ('130608', 'MACHE', '1306', '13'), ('130610', 'PARANDAY', '1306', '13'), ('130611', 'SALPO', '1306', '13'), ('130613', 'SINSICAP', '1306', '13'), ('130614', 'USQUIL', '1306', '13'), ('130700', 'PACASMAYO', '1307', '13'), ('130701', 'SAN PEDRO DE LLOC', '1307', '13'), ('130702', 'GUADALUPE', '1307', '13'), ('130703', 'JEQUETEPEQUE', '1307', '13'), ('130704', 'PACASMAYO', '1307', '13'), ('130705', 'SAN JOSE', '1307', '13'), ('130800', 'PATAZ', '1308', '13'), ('130801', 'TAYABAMBA', '1308', '13'), ('130802', 'BULDIBUYO', '1308', '13'), ('130803', 'CHILLIA', '1308', '13'), ('130804', 'HUANCASPATA', '1308', '13'), ('130805', 'HUAYLILLAS', '1308', '13'), ('130806', 'HUAYO', '1308', '13');
INSERT INTO `tb_distrito` VALUES ('130807', 'ONGON', '1308', '13'), ('130808', 'PARCOY', '1308', '13'), ('130809', 'PATAZ', '1308', '13'), ('130810', 'PIAS', '1308', '13'), ('130811', 'SANTIAGO DE CHALLAS', '1308', '13'), ('130812', 'TAURIJA', '1308', '13'), ('130813', 'URPAY', '1308', '13'), ('130900', 'SANCHEZ CARRION', '1309', '13'), ('130901', 'HUAMACHUCO', '1309', '13'), ('130902', 'CHUGAY', '1309', '13'), ('130903', 'COCHORCO', '1309', '13'), ('130904', 'CURGOS', '1309', '13'), ('130905', 'MARCABAL', '1309', '13'), ('130906', 'SANAGORAN', '1309', '13'), ('130907', 'SARIN', '1309', '13'), ('130908', 'SARTIMBAMBA', '1309', '13'), ('131000', 'SANTIAGO DE CHUCO', '1310', '13'), ('131001', 'SANTIAGO DE CHUCO', '1310', '13'), ('131002', 'ANGASMARCA', '1310', '13'), ('131003', 'CACHICADAN', '1310', '13'), ('131004', 'MOLLEBAMBA', '1310', '13'), ('131005', 'MOLLEPATA', '1310', '13'), ('131006', 'QUIRUVILCA', '1310', '13'), ('131007', 'SANTA CRUZ DE CHUCA', '1310', '13'), ('131008', 'SITABAMBA', '1310', '13'), ('131100', 'GRAN CHIMU', '1311', '13'), ('131101', 'CASCAS', '1311', '13'), ('131102', 'LUCMA', '1311', '13'), ('131103', 'MARMOT', '1311', '13'), ('131104', 'SAYAPULLO', '1311', '13'), ('131200', 'VIRU', '1312', '13'), ('131201', 'VIRU', '1312', '13'), ('131202', 'CHAO', '1312', '13'), ('131203', 'GUADALUPITO', '1312', '13'), ('140000', 'LAMBAYEQUE', '1400', '14'), ('140100', 'CHICLAYO', '1401', '14'), ('140101', 'CHICLAYO', '1401', '14'), ('140102', 'CHONGOYAPE', '1401', '14'), ('140103', 'ETEN', '1401', '14'), ('140104', 'ETEN PUERTO', '1401', '14'), ('140105', 'JOSE LEONARDO ORTIZ', '1401', '14'), ('140106', 'LA VICTORIA', '1401', '14'), ('140107', 'LAGUNAS', '1401', '14'), ('140108', 'MONSEFU', '1401', '14'), ('140109', 'NUEVA ARICA', '1401', '14'), ('140110', 'OYOTUN', '1401', '14'), ('140111', 'PICSI', '1401', '14'), ('140112', 'PIMENTEL', '1401', '14'), ('140113', 'REQUE', '1401', '14'), ('140114', 'SANTA ROSA', '1401', '14'), ('140115', 'SAÑA', '1401', '14'), ('140116', 'CAYALTI', '1401', '14'), ('140117', 'PATAPO', '1401', '14'), ('140118', 'POMALCA', '1401', '14'), ('140119', 'PUCALA', '1401', '14'), ('140120', 'TUMAN', '1401', '14'), ('140200', 'FERREÑAFE', '1402', '14'), ('140201', 'FERREÑAFE', '1402', '14'), ('140202', 'CAÑARIS', '1402', '14'), ('140203', 'INCAHUASI', '1402', '14'), ('140204', 'MANUEL ANTONIO MESONES MURO', '1402', '14'), ('140205', 'PITIPO', '1402', '14'), ('140206', 'PUEBLO NUEVO', '1402', '14'), ('140300', 'LAMBAYEQUE', '1403', '14'), ('140301', 'LAMBAYEQUE', '1403', '14'), ('140302', 'CHOCHOPE', '1403', '14'), ('140303', 'ILLIMO', '1403', '14'), ('140304', 'JAYANCA', '1403', '14'), ('140305', 'MOCHUMI', '1403', '14'), ('140306', 'MORROPE', '1403', '14'), ('140307', 'MOTUPE', '1403', '14'), ('140308', 'OLMOS', '1403', '14'), ('140309', 'PACORA', '1403', '14'), ('140310', 'SALAS', '1403', '14'), ('140311', 'SAN JOSE', '1403', '14'), ('140312', 'TUCUME', '1403', '14'), ('150000', 'LIMA', '1500', '15'), ('150100', 'LIMA', '1501', '15'), ('150101', 'LIMA', '1501', '15'), ('150102', 'ANCON', '1501', '15'), ('150103', 'ATE', '1501', '15'), ('150104', 'BARRANCO', '1501', '15'), ('150105', 'BREÑA', '1501', '15'), ('150106', 'CARABAYLLO', '1501', '15'), ('150107', 'CHACLACAYO', '1501', '15'), ('150108', 'CHORRILLOS', '1501', '15'), ('150109', 'CIENEGUILLA', '1501', '15'), ('150110', 'COMAS', '1501', '15'), ('150111', 'EL AGUSTINO', '1501', '15'), ('150112', 'INDEPENDENCIA', '1501', '15'), ('150113', 'JESUS MARIA', '1501', '15'), ('150114', 'LA MOLINA', '1501', '15'), ('150115', 'LA VICTORIA', '1501', '15'), ('150116', 'LINCE', '1501', '15'), ('150117', 'LOS OLIVOS', '1501', '15'), ('150118', 'LURIGANCHO', '1501', '15'), ('150119', 'LURIN', '1501', '15'), ('150120', 'MAGDALENA DEL MAR', '1501', '15'), ('150121', 'PUEBLO LIBRE', '1501', '15'), ('150122', 'MIRAFLORES', '1501', '15'), ('150123', 'PACHACAMAC', '1501', '15');
INSERT INTO `tb_distrito` VALUES ('150124', 'PUCUSANA', '1501', '15'), ('150125', 'PUENTE PIEDRA', '1501', '15'), ('150126', 'PUNTA HERMOSA', '1501', '15'), ('150127', 'PUNTA NEGRA', '1501', '15'), ('150128', 'RIMAC', '1501', '15'), ('150129', 'SAN BARTOLO', '1501', '15'), ('150130', 'SAN BORJA', '1501', '15'), ('150131', 'SAN ISIDRO', '1501', '15'), ('150132', 'SAN JUAN DE LURIGANCHO', '1501', '15'), ('150133', 'SAN JUAN DE MIRAFLORES', '1501', '15'), ('150134', 'SAN LUIS', '1501', '15'), ('150135', 'SAN MARTIN DE PORRES', '1501', '15'), ('150136', 'SAN MIGUEL', '1501', '15'), ('150137', 'SANTA ANITA', '1501', '15'), ('150138', 'SANTA MARIA DEL MAR', '1501', '15'), ('150139', 'SANTA ROSA', '1501', '15'), ('150140', 'SANTIAGO DE SURCO', '1501', '15'), ('150141', 'SURQUILLO', '1501', '15'), ('150142', 'VILLA EL SALVADOR', '1501', '15'), ('150143', 'VILLA MARIA DEL TRIUNFO', '1501', '15'), ('150200', 'BARRANCA', '1502', '15'), ('150201', 'BARRANCA', '1502', '15'), ('150202', 'PARAMONGA', '1502', '15'), ('150203', 'PATIVILCA', '1502', '15'), ('150204', 'SUPE', '1502', '15'), ('150205', 'SUPE PUERTO', '1502', '15'), ('150300', 'CAJATAMBO', '1503', '15'), ('150301', 'CAJATAMBO', '1503', '15'), ('150302', 'COPA', '1503', '15'), ('150303', 'GORGOR', '1503', '15'), ('150304', 'HUANCAPON', '1503', '15'), ('150305', 'MANAS', '1503', '15'), ('150400', 'CANTA', '1504', '15'), ('150401', 'CANTA', '1504', '15'), ('150402', 'ARAHUAY', '1504', '15'), ('150403', 'HUAMANTANGA', '1504', '15'), ('150404', 'HUAROS', '1504', '15'), ('150405', 'LACHAQUI', '1504', '15'), ('150406', 'SAN BUENAVENTURA', '1504', '15'), ('150407', 'SANTA ROSA DE QUIVES', '1504', '15'), ('150500', 'SAN VICENTE DE CAÑETE', '1505', '15'), ('150501', 'SAN VICENTE DE CAÑETE', '1505', '15'), ('150502', 'ASIA', '1505', '15'), ('150503', 'CALANGO', '1505', '15'), ('150504', 'CERRO AZUL', '1505', '15'), ('150505', 'CHILCA', '1505', '15'), ('150506', 'COAYLLO', '1505', '15'), ('150507', 'IMPERIAL', '1505', '15'), ('150508', 'LUNAHUANA', '1505', '15'), ('150509', 'MALA', '1505', '15'), ('150510', 'NUEVO IMPERIAL', '1505', '15'), ('150511', 'PACARAN', '1505', '15'), ('150512', 'QUILMANA', '1505', '15'), ('150513', 'SAN ANTONIO', '1505', '15'), ('150514', 'SAN LUIS', '1505', '15'), ('150515', 'SANTA CRUZ DE FLORES', '1505', '15'), ('150516', 'ZUÑIGA', '1505', '15'), ('150600', 'HUARAL', '1506', '15'), ('150601', 'HUARAL', '1506', '15'), ('150602', 'ATAVILLOS ALTO', '1506', '15'), ('150603', 'ATAVILLOS BAJO', '1506', '15'), ('150604', 'AUCALLAMA', '1506', '15'), ('150605', 'CHANCAY', '1506', '15'), ('150606', 'IHUARI', '1506', '15'), ('150607', 'LAMPIAN', '1506', '15'), ('150608', 'PACARAOS', '1506', '15'), ('150609', 'SAN MIGUEL DE ACOS', '1506', '15'), ('150610', 'SANTA CRUZ DE ANDAMARCA', '1506', '15'), ('150611', 'SUMBILCA', '1506', '15'), ('150612', 'VEINTISIETE DE NOVIEMBRE', '1506', '15'), ('150700', 'HUAROCHIRI', '1507', '15'), ('150701', 'MATUCANA', '1507', '15'), ('150702', 'ANTIOQUIA', '1507', '15'), ('150703', 'CALLAHUANCA', '1507', '15'), ('150704', 'CARAMPOMA', '1507', '15'), ('150705', 'CHICLA', '1507', '15'), ('150706', 'CUENCA', '1507', '15'), ('150707', 'HUACHUPAMPA', '1507', '15'), ('150708', 'HUANZA', '1507', '15'), ('150709', 'HUAROCHIRI', '1507', '15'), ('150710', 'LAHUAYTAMBO', '1507', '15'), ('150711', 'LANGA', '1507', '15'), ('150712', 'LARAOS', '1507', '15'), ('150713', 'MARIATANA', '1507', '15'), ('150714', 'RICARDO PALMA', '1507', '15'), ('150715', 'SAN ANDRES DE TUPICOCHA', '1507', '15'), ('150716', 'SAN ANTONIO', '1507', '15'), ('150717', 'SAN BARTOLOME', '1507', '15'), ('150718', 'SAN DAMIAN', '1507', '15'), ('150719', 'SAN JUAN DE IRIS', '1507', '15'), ('150720', 'SAN JUAN DE TANTARANCHE', '1507', '15'), ('150721', 'SAN LORENZO DE QUINTI', '1507', '15'), ('150722', 'SAN MATEO', '1507', '15'), ('150723', 'SAN MATEO DE OTAO', '1507', '15'), ('150724', 'SAN PEDRO DE CASTA', '1507', '15'), ('150725', 'SAN PEDRO DE HUANCAYRE', '1507', '15'), ('150726', 'SANGALLAYA', '1507', '15'), ('150727', 'SANTA CRUZ DE COCACHACRA', '1507', '15'), ('150728', 'SANTA EULALIA', '1507', '15'), ('150729', 'SANTIAGO DE ANCHUCAYA', '1507', '15'), ('150730', 'SANTIAGO DE TUNA', '1507', '15');
INSERT INTO `tb_distrito` VALUES ('150731', 'SANTO DOMINGO DE LOS OLLEROS', '1507', '15'), ('150732', 'SURCO', '1507', '15'), ('150800', 'HUAURA', '1508', '15'), ('150801', 'HUACHO', '1508', '15'), ('150802', 'AMBAR', '1508', '15'), ('150803', 'CALETA DE CARQUIN', '1508', '15'), ('150804', 'CHECRAS', '1508', '15'), ('150805', 'HUALMAY', '1508', '15'), ('150806', 'HUAURA', '1508', '15'), ('150807', 'LEONCIO PRADO', '1508', '15'), ('150808', 'PACCHO', '1508', '15'), ('150809', 'SANTA LEONOR', '1508', '15'), ('150810', 'SANTA MARIA', '1508', '15'), ('150811', 'SAYAN', '1508', '15'), ('150812', 'VEGUETA', '1508', '15'), ('150900', 'OYON', '1509', '15'), ('150901', 'OYON', '1509', '15'), ('150902', 'ANDAJES', '1509', '15'), ('150903', 'CAUJUL', '1509', '15'), ('150904', 'COCHAMARCA', '1509', '15'), ('150905', 'NAVAN', '1509', '15'), ('150906', 'PACHANGARA', '1509', '15'), ('151000', 'YAUYOS', '1510', '15'), ('151001', 'YAUYOS', '1510', '15'), ('151002', 'ALIS', '1510', '15'), ('151003', 'AYAUCA', '1510', '15'), ('151004', 'AYAVIRI', '1510', '15'), ('151005', 'AZANGARO', '1510', '15'), ('151006', 'CACRA', '1510', '15'), ('151007', 'CARANIA', '1510', '15'), ('151008', 'CATAHUASI', '1510', '15'), ('151009', 'CHOCOS', '1510', '15'), ('151010', 'COCHAS', '1510', '15'), ('151011', 'COLONIA', '1510', '15'), ('151012', 'HONGOS', '1510', '15'), ('151013', 'HUAMPARA', '1510', '15'), ('151014', 'HUANCAYA', '1510', '15'), ('151015', 'HUANGASCAR', '1510', '15'), ('151016', 'HUANTAN', '1510', '15'), ('151017', 'HUAÑEC', '1510', '15'), ('151018', 'LARAOS', '1510', '15'), ('151019', 'LINCHA', '1510', '15'), ('151020', 'MADEAN', '1510', '15'), ('151021', 'MIRAFLORES', '1510', '15'), ('151022', 'OMAS', '1510', '15'), ('151023', 'PUTINZA', '1510', '15'), ('151024', 'QUINCHES', '1510', '15'), ('151025', 'QUINOCAY', '1510', '15'), ('151026', 'SAN JOAQUIN', '1510', '15'), ('151027', 'SAN PEDRO DE PILAS', '1510', '15'), ('151028', 'TANTA', '1510', '15'), ('151029', 'TAURIPAMPA', '1510', '15'), ('151030', 'TOMAS', '1510', '15'), ('151031', 'TUPE', '1510', '15'), ('151032', 'VIÑAC', '1510', '15'), ('151033', 'VITIS', '1510', '15'), ('160000', 'LORETO', '1600', '16'), ('160100', 'MAYNAS', '1601', '16'), ('160101', 'IQUITOS', '1601', '16'), ('160102', 'ALTO NANAY', '1601', '16'), ('160103', 'FERNANDO LORES', '1601', '16'), ('160104', 'INDIANA', '1601', '16'), ('160105', 'LAS AMAZONAS', '1601', '16'), ('160106', 'MAZAN', '1601', '16'), ('160107', 'NAPO', '1601', '16'), ('160108', 'PUNCHANA', '1601', '16'), ('160109', 'PUTUMAYO', '1601', '16'), ('160110', 'TORRES CAUSANA', '1601', '16'), ('160112', 'BELEN', '1601', '16'), ('160113', 'SAN JUAN BAUTISTA', '1601', '16'), ('160200', 'ALTO AMAZONAS', '1602', '16'), ('160201', 'YURIMAGUAS', '1602', '16'), ('160202', 'BALSAPUERTO', '1602', '16'), ('160203', 'BARRANCA', '1602', '16'), ('160204', 'CAHUAPANAS', '1602', '16'), ('160205', 'JEBEROS', '1602', '16'), ('160206', 'LAGUNAS', '1602', '16'), ('160207', 'MANSERICHE', '1602', '16'), ('160208', 'MORONA', '1602', '16'), ('160209', 'PASTAZA', '1602', '16'), ('160210', 'SANTA CRUZ', '1602', '16'), ('160211', 'TENIENTE CESAR LOPEZ ROJAS', '1602', '16'), ('160300', 'LORETO', '1603', '16'), ('160301', 'NAUTA', '1603', '16'), ('160302', 'PARINARI', '1603', '16'), ('160303', 'TIGRE', '1603', '16'), ('160304', 'TROMPETEROS', '1603', '16'), ('160305', 'URARINAS', '1603', '16'), ('160400', 'MARISCAL RAMON CASTILLA', '1604', '16'), ('160401', 'RAMON CASTILLA', '1604', '16'), ('160402', 'PEBAS', '1604', '16'), ('160403', 'YAVARI', '1604', '16'), ('160404', 'SAN PABLO', '1604', '16'), ('160500', 'REQUENA', '1605', '16'), ('160501', 'REQUENA', '1605', '16'), ('160502', 'ALTO TAPICHE', '1605', '16'), ('160503', 'CAPELO', '1605', '16'), ('160504', 'EMILIO SAN MARTIN', '1605', '16'), ('160505', 'MAQUIA', '1605', '16'), ('160506', 'PUINAHUA', '1605', '16'), ('160507', 'SAQUENA', '1605', '16');
INSERT INTO `tb_distrito` VALUES ('160508', 'SOPLIN', '1605', '16'), ('160509', 'TAPICHE', '1605', '16'), ('160510', 'JENARO HERRERA', '1605', '16'), ('160511', 'YAQUERANA', '1605', '16'), ('160600', 'UCAYALI', '1606', '16'), ('160601', 'CONTAMANA', '1606', '16'), ('160602', 'INAHUAYA', '1606', '16'), ('160603', 'PADRE MARQUEZ', '1606', '16'), ('160604', 'PAMPA HERMOSA', '1606', '16'), ('160605', 'SARAYACU', '1606', '16'), ('160606', 'VARGAS GUERRA', '1606', '16'), ('170000', 'MADRE DE DIOS', '1700', '17'), ('170100', 'TAMBOPATA', '1701', '17'), ('170101', 'TAMBOPATA', '1701', '17'), ('170102', 'INAMBARI', '1701', '17'), ('170103', 'LAS PIEDRAS', '1701', '17'), ('170104', 'LABERINTO', '1701', '17'), ('170200', 'MANU', '1702', '17'), ('170201', 'MANU', '1702', '17'), ('170202', 'FITZCARRALD', '1702', '17'), ('170203', 'MADRE DE DIOS', '1702', '17'), ('170204', 'HUEPETUHE', '1702', '17'), ('170300', 'IÑAPARI', '1703', '17'), ('170301', 'IÑAPARI', '1703', '17'), ('170302', 'IBERIA', '1703', '17'), ('170303', 'TAHUAMANU', '1703', '17'), ('180000', 'MOQUEGUA', '1800', '18'), ('180100', 'MARISCAL NIETO', '1801', '18'), ('180101', 'MOQUEGUA', '1801', '18'), ('180102', 'CARUMAS', '1801', '18'), ('180103', 'CUCHUMBAYA', '1801', '18'), ('180104', 'SAMEGUA', '1801', '18'), ('180105', 'SAN CRISTOBAL', '1801', '18'), ('180106', 'TORATA', '1801', '18'), ('180200', 'GENERAL SANCHEZ CERRO', '1802', '18'), ('180201', 'OMATE', '1802', '18'), ('180202', 'CHOJATA', '1802', '18'), ('180203', 'COALAQUE', '1802', '18'), ('180204', 'ICHUÑA', '1802', '18'), ('180205', 'LA CAPILLA', '1802', '18'), ('180206', 'LLOQUE', '1802', '18'), ('180207', 'MATALAQUE', '1802', '18'), ('180208', 'PUQUINA', '1802', '18'), ('180209', 'QUINISTAQUILLAS', '1802', '18'), ('180210', 'UBINAS', '1802', '18'), ('180211', 'YUNGA', '1802', '18'), ('180300', 'ILO', '1803', '18'), ('180301', 'ILO', '1803', '18'), ('180302', 'EL ALGARROBAL', '1803', '18'), ('180303', 'PACOCHA', '1803', '18'), ('190000', 'PASCO', '1900', '19'), ('190100', 'PASCO', '1901', '19'), ('190101', 'CHAUPIMARCA', '1901', '19'), ('190102', 'HUACHON', '1901', '19'), ('190103', 'HUARIACA', '1901', '19'), ('190104', 'HUAYLLAY', '1901', '19'), ('190105', 'NINACACA', '1901', '19'), ('190106', 'PALLANCHACRA', '1901', '19'), ('190107', 'PAUCARTAMBO', '1901', '19'), ('190108', 'SAN FCO.DE ASIS DE YARUSYACAN', '1901', '19'), ('190109', 'SIMON BOLIVAR', '1901', '19'), ('190110', 'TICLACAYAN', '1901', '19'), ('190111', 'TINYAHUARCO', '1901', '19'), ('190112', 'VICCO', '1901', '19'), ('190113', 'YANACANCHA', '1901', '19'), ('190200', 'DANIEL ALCIDES CARRION', '1902', '19'), ('190201', 'YANAHUANCA', '1902', '19'), ('190202', 'CHACAYAN', '1902', '19'), ('190203', 'GOYLLARISQUIZGA', '1902', '19'), ('190204', 'PAUCAR', '1902', '19'), ('190205', 'SAN PEDRO DE PILLAO', '1902', '19'), ('190206', 'SANTA ANA DE TUSI', '1902', '19'), ('190207', 'TAPUC', '1902', '19'), ('190208', 'VILCABAMBA', '1902', '19'), ('190300', 'OXAPAMPA', '1903', '19'), ('190301', 'OXAPAMPA', '1903', '19'), ('190302', 'CHONTABAMBA', '1903', '19'), ('190303', 'HUANCABAMBA', '1903', '19'), ('190304', 'PALCAZU', '1903', '19'), ('190305', 'POZUZO', '1903', '19'), ('190306', 'PUERTO BERMUDEZ', '1903', '19'), ('190307', 'VILLA RICA', '1903', '19'), ('200000', 'PIURA', '2000', '20'), ('200100', 'PIURA', '2001', '20'), ('200101', 'PIURA', '2001', '20'), ('200104', 'CASTILLA', '2001', '20'), ('200105', 'CATACAOS', '2001', '20'), ('200107', 'CURA MORI', '2001', '20'), ('200108', 'EL TALLAN', '2001', '20'), ('200109', 'LA ARENA', '2001', '20'), ('200110', 'LA UNION', '2001', '20'), ('200111', 'LAS LOMAS', '2001', '20'), ('200114', 'TAMBO GRANDE', '2001', '20'), ('200200', 'AYABACA', '2002', '20'), ('200201', 'AYABACA', '2002', '20'), ('200202', 'FRIAS', '2002', '20'), ('200203', 'JILILI', '2002', '20'), ('200204', 'LAGUNAS', '2002', '20'), ('200205', 'MONTERO', '2002', '20'), ('200206', 'PACAIPAMPA', '2002', '20'), ('200207', 'PAIMAS', '2002', '20');
INSERT INTO `tb_distrito` VALUES ('200208', 'SAPILLICA', '2002', '20'), ('200209', 'SICCHEZ', '2002', '20'), ('200210', 'SUYO', '2002', '20'), ('200300', 'HUANCABAMBA', '2003', '20'), ('200301', 'HUANCABAMBA', '2003', '20'), ('200302', 'CANCHAQUE', '2003', '20'), ('200303', 'EL CARMEN DE LA FRONTERA', '2003', '20'), ('200304', 'HUARMACA', '2003', '20'), ('200305', 'LALAQUIZ', '2003', '20'), ('200306', 'SAN MIGUEL DE EL FAIQUE', '2003', '20'), ('200307', 'SONDOR', '2003', '20'), ('200308', 'SONDORILLO', '2003', '20'), ('200400', 'MORROPON', '2004', '20'), ('200401', 'CHULUCANAS', '2004', '20'), ('200402', 'BUENOS AIRES', '2004', '20'), ('200403', 'CHALACO', '2004', '20'), ('200404', 'LA MATANZA', '2004', '20'), ('200405', 'MORROPON', '2004', '20'), ('200406', 'SALITRAL', '2004', '20'), ('200407', 'SAN JUAN DE BIGOTE', '2004', '20'), ('200408', 'SANTA CATALINA DE MOSSA', '2004', '20'), ('200409', 'SANTO DOMINGO', '2004', '20'), ('200410', 'YAMANGO', '2004', '20'), ('200500', 'PAITA', '2005', '20'), ('200501', 'PAITA', '2005', '20'), ('200502', 'AMOTAPE', '2005', '20'), ('200503', 'ARENAL', '2005', '20'), ('200504', 'COLAN', '2005', '20'), ('200505', 'LA HUACA', '2005', '20'), ('200506', 'TAMARINDO', '2005', '20'), ('200507', 'VICHAYAL', '2005', '20'), ('200600', 'SULLANA', '2006', '20'), ('200601', 'SULLANA', '2006', '20'), ('200602', 'BELLAVISTA', '2006', '20'), ('200603', 'IGNACIO ESCUDERO', '2006', '20'), ('200604', 'LANCONES', '2006', '20'), ('200605', 'MARCAVELICA', '2006', '20'), ('200606', 'MIGUEL CHECA', '2006', '20'), ('200607', 'QUERECOTILLO', '2006', '20'), ('200608', 'SALITRAL', '2006', '20'), ('200700', 'TALARA', '2007', '20'), ('200701', 'PARIÑAS', '2007', '20'), ('200702', 'EL ALTO', '2007', '20'), ('200703', 'LA BREA', '2007', '20'), ('200704', 'LOBITOS', '2007', '20'), ('200705', 'LOS ORGANOS', '2007', '20'), ('200706', 'MANCORA', '2007', '20'), ('200800', 'SECHURA', '2008', '20'), ('200801', 'SECHURA', '2008', '20'), ('200802', 'BELLAVISTA DE LA UNION', '2008', '20'), ('200803', 'BERNAL', '2008', '20'), ('200804', 'CRISTO NOS VALGA', '2008', '20'), ('200805', 'VICE', '2008', '20'), ('200806', 'RINCONADA LLICUAR', '2008', '20'), ('210000', 'PUNO', '2100', '21'), ('210100', 'PUNO', '2101', '21'), ('210101', 'PUNO', '2101', '21'), ('210102', 'ACORA', '2101', '21'), ('210103', 'AMANTANI', '2101', '21'), ('210104', 'ATUNCOLLA', '2101', '21'), ('210105', 'CAPACHICA', '2101', '21'), ('210106', 'CHUCUITO', '2101', '21'), ('210107', 'COATA', '2101', '21'), ('210108', 'HUATA', '2101', '21'), ('210109', 'MAÑAZO', '2101', '21'), ('210110', 'PAUCARCOLLA', '2101', '21'), ('210111', 'PICHACANI', '2101', '21'), ('210112', 'PLATERIA', '2101', '21'), ('210113', 'SAN ANTONIO', '2101', '21'), ('210114', 'TIQUILLACA', '2101', '21'), ('210115', 'VILQUE', '2101', '21'), ('210200', 'AZANGARO', '2102', '21'), ('210201', 'AZANGARO', '2102', '21'), ('210202', 'ACHAYA', '2102', '21'), ('210203', 'ARAPA', '2102', '21'), ('210204', 'ASILLO', '2102', '21'), ('210205', 'CAMINACA', '2102', '21'), ('210206', 'CHUPA', '2102', '21'), ('210207', 'JOSE DOMINGO CHOQUEHUANCA', '2102', '21'), ('210208', 'MUÑANI', '2102', '21'), ('210209', 'POTONI', '2102', '21'), ('210210', 'SAMAN', '2102', '21'), ('210211', 'SAN ANTON', '2102', '21'), ('210212', 'SAN JOSE', '2102', '21'), ('210213', 'SAN JUAN DE SALINAS', '2102', '21'), ('210214', 'SANTIAGO DE PUPUJA', '2102', '21'), ('210215', 'TIRAPATA', '2102', '21'), ('210300', 'CARABAYA', '2103', '21'), ('210301', 'MACUSANI', '2103', '21'), ('210302', 'AJOYANI', '2103', '21'), ('210303', 'AYAPATA', '2103', '21'), ('210304', 'COASA', '2103', '21'), ('210305', 'CORANI', '2103', '21'), ('210306', 'CRUCERO', '2103', '21'), ('210307', 'ITUATA', '2103', '21'), ('210308', 'OLLACHEA', '2103', '21'), ('210309', 'SAN GABAN', '2103', '21'), ('210310', 'USICAYOS', '2103', '21'), ('210400', 'CHUCUITO', '2104', '21'), ('210401', 'JULI', '2104', '21'), ('210402', 'DESAGUADERO', '2104', '21');
INSERT INTO `tb_distrito` VALUES ('210403', 'HUACULLANI', '2104', '21'), ('210404', 'KELLUYO', '2104', '21'), ('210405', 'PISACOMA', '2104', '21'), ('210406', 'POMATA', '2104', '21'), ('210407', 'ZEPITA', '2104', '21'), ('210500', 'EL COLLAO', '2105', '21'), ('210501', 'ILAVE', '2105', '21'), ('210502', 'CAPASO', '2105', '21'), ('210503', 'PILCUYO', '2105', '21'), ('210504', 'SANTA ROSA', '2105', '21'), ('210505', 'CONDURIRI', '2105', '21'), ('210600', 'HUANCANE', '2106', '21'), ('210601', 'HUANCANE', '2106', '21'), ('210602', 'COJATA', '2106', '21'), ('210603', 'HUATASANI', '2106', '21'), ('210604', 'INCHUPALLA', '2106', '21'), ('210605', 'PUSI', '2106', '21'), ('210606', 'ROSASPATA', '2106', '21'), ('210607', 'TARACO', '2106', '21'), ('210608', 'VILQUE CHICO', '2106', '21'), ('210700', 'LAMPA', '2107', '21'), ('210701', 'LAMPA', '2107', '21'), ('210702', 'CABANILLA', '2107', '21'), ('210703', 'CALAPUJA', '2107', '21'), ('210704', 'NICASIO', '2107', '21'), ('210705', 'OCUVIRI', '2107', '21'), ('210706', 'PALCA', '2107', '21'), ('210707', 'PARATIA', '2107', '21'), ('210708', 'PUCARA', '2107', '21'), ('210709', 'SANTA LUCIA', '2107', '21'), ('210710', 'VILAVILA', '2107', '21'), ('210800', 'MELGAR', '2108', '21'), ('210801', 'AYAVIRI', '2108', '21'), ('210802', 'ANTAUTA', '2108', '21'), ('210803', 'CUPI', '2108', '21'), ('210804', 'LLALLI', '2108', '21'), ('210805', 'MACARI', '2108', '21'), ('210806', 'NUÑOA', '2108', '21'), ('210807', 'ORURILLO', '2108', '21'), ('210808', 'SANTA ROSA', '2108', '21'), ('210809', 'UMACHIRI', '2108', '21'), ('210900', 'MOHO', '2109', '21'), ('210901', 'MOHO', '2109', '21'), ('210902', 'CONIMA', '2109', '21'), ('210903', 'HUAYRAPATA', '2109', '21'), ('210904', 'TILALI', '2109', '21'), ('211000', 'SAN ANTONIO DE PUTINA', '2110', '21'), ('211001', 'PUTINA', '2110', '21'), ('211002', 'ANANEA', '2110', '21'), ('211003', 'PEDRO VILCA APAZA', '2110', '21'), ('211004', 'QUILCAPUNCU', '2110', '21'), ('211005', 'SINA', '2110', '21'), ('211100', 'SAN ROMAN', '2111', '21'), ('211101', 'JULIACA', '2111', '21'), ('211102', 'CABANA', '2111', '21'), ('211103', 'CABANILLAS', '2111', '21'), ('211104', 'CARACOTO', '2111', '21'), ('211200', 'SANDIA', '2112', '21'), ('211201', 'SANDIA', '2112', '21'), ('211202', 'CUYOCUYO', '2112', '21'), ('211203', 'LIMBANI', '2112', '21'), ('211204', 'PATAMBUCO', '2112', '21'), ('211205', 'PHARA', '2112', '21'), ('211206', 'QUIACA', '2112', '21'), ('211207', 'SAN JUAN DEL ORO', '2112', '21'), ('211208', 'YANAHUAYA', '2112', '21'), ('211209', 'ALTO INAMBARI', '2112', '21'), ('211300', 'YUNGUYO', '2113', '21'), ('211301', 'YUNGUYO', '2113', '21'), ('211302', 'ANAPIA', '2113', '21'), ('211303', 'COPANI', '2113', '21'), ('211304', 'CUTURAPI', '2113', '21'), ('211305', 'OLLARAYA', '2113', '21'), ('211306', 'TINICACHI', '2113', '21'), ('211307', 'UNICACHI', '2113', '21'), ('220000', 'SAN MARTIN', '2200', '22'), ('220100', 'MOYOBAMBA', '2201', '22'), ('220101', 'MOYOBAMBA', '2201', '22'), ('220102', 'CALZADA', '2201', '22'), ('220103', 'HABANA', '2201', '22'), ('220104', 'JEPELACIO', '2201', '22'), ('220105', 'SORITOR', '2201', '22'), ('220106', 'YANTALO', '2201', '22'), ('220200', 'BELLAVISTA', '2202', '22'), ('220201', 'BELLAVISTA', '2202', '22'), ('220202', 'ALTO BIAVO', '2202', '22'), ('220203', 'BAJO BIAVO', '2202', '22'), ('220204', 'HUALLAGA', '2202', '22'), ('220205', 'SAN PABLO', '2202', '22'), ('220206', 'SAN RAFAEL', '2202', '22'), ('220300', 'EL DORADO', '2203', '22'), ('220301', 'SAN JOSE DE SISA', '2203', '22'), ('220302', 'AGUA BLANCA', '2203', '22'), ('220303', 'SAN MARTIN', '2203', '22'), ('220304', 'SANTA ROSA', '2203', '22'), ('220305', 'SHATOJA', '2203', '22'), ('220400', 'HUALLAGA', '2204', '22'), ('220401', 'SAPOSOA', '2204', '22'), ('220402', 'ALTO SAPOSOA', '2204', '22'), ('220403', 'EL ESLABON', '2204', '22'), ('220404', 'PISCOYACU', '2204', '22');
INSERT INTO `tb_distrito` VALUES ('220405', 'SACANCHE', '2204', '22'), ('220406', 'TINGO DE SAPOSOA', '2204', '22'), ('220500', 'LAMAS', '2205', '22'), ('220501', 'LAMAS', '2205', '22'), ('220502', 'ALONSO DE ALVARADO', '2205', '22'), ('220503', 'BARRANQUITA', '2205', '22'), ('220504', 'CAYNARACHI', '2205', '22'), ('220505', 'CUÑUMBUQUI', '2205', '22'), ('220506', 'PINTO RECODO', '2205', '22'), ('220507', 'RUMISAPA', '2205', '22'), ('220508', 'SAN ROQUE DE CUMBAZA', '2205', '22'), ('220509', 'SHANAO', '2205', '22'), ('220510', 'TABALOSOS', '2205', '22'), ('220511', 'ZAPATERO', '2205', '22'), ('220600', 'MARISCAL CACERES', '2206', '22'), ('220601', 'JUANJUI', '2206', '22'), ('220602', 'CAMPANILLA', '2206', '22'), ('220603', 'HUICUNGO', '2206', '22'), ('220604', 'PACHIZA', '2206', '22'), ('220605', 'PAJARILLO', '2206', '22'), ('220700', 'PICOTA', '2207', '22'), ('220701', 'PICOTA', '2207', '22'), ('220702', 'BUENOS AIRES', '2207', '22'), ('220703', 'CASPISAPA', '2207', '22'), ('220704', 'PILLUANA', '2207', '22'), ('220705', 'PUCACACA', '2207', '22'), ('220706', 'SAN CRISTOBAL', '2207', '22'), ('220707', 'SAN HILARION', '2207', '22'), ('220708', 'SHAMBOYACU', '2207', '22'), ('220709', 'TINGO DE PONASA', '2207', '22'), ('220710', 'TRES UNIDOS', '2207', '22'), ('220800', 'RIOJA', '2208', '22'), ('220801', 'RIOJA', '2208', '22'), ('220802', 'AWAJUN', '2208', '22'), ('220803', 'ELIAS SOPLIN VARGAS', '2208', '22'), ('220804', 'NUEVA CAJAMARCA', '2208', '22'), ('220805', 'PARDO MIGUEL', '2208', '22'), ('220806', 'POSIC', '2208', '22'), ('220807', 'SAN FERNANDO', '2208', '22'), ('220808', 'YORONGOS', '2208', '22'), ('220809', 'YURACYACU', '2208', '22'), ('220900', 'SAN MARTIN', '2209', '22'), ('220901', 'TARAPOTO', '2209', '22'), ('220902', 'ALBERTO LEVEAU', '2209', '22'), ('220903', 'CACATACHI', '2209', '22'), ('220904', 'CHAZUTA', '2209', '22'), ('220905', 'CHIPURANA', '2209', '22'), ('220906', 'EL PORVENIR', '2209', '22'), ('220907', 'HUIMBAYOC', '2209', '22'), ('220908', 'JUAN GUERRA', '2209', '22'), ('220909', 'LA BANDA DE SHILCAYO', '2209', '22'), ('220910', 'MORALES', '2209', '22'), ('220911', 'PAPAPLAYA', '2209', '22'), ('220912', 'SAN ANTONIO', '2209', '22'), ('220913', 'SAUCE', '2209', '22'), ('220914', 'SHAPAJA', '2209', '22'), ('221000', 'TOCACHE', '2210', '22'), ('221001', 'TOCACHE', '2210', '22'), ('221002', 'NUEVO PROGRESO', '2210', '22'), ('221003', 'POLVORA', '2210', '22'), ('221004', 'SHUNTE', '2210', '22'), ('221005', 'UCHIZA', '2210', '22'), ('230000', 'TACNA', '2300', '23'), ('230100', 'TACNA', '2301', '23'), ('230101', 'TACNA', '2301', '23'), ('230102', 'ALTO DE LA ALIANZA', '2301', '23'), ('230103', 'CALANA', '2301', '23'), ('230104', 'CIUDAD NUEVA', '2301', '23'), ('230105', 'INCLAN', '2301', '23'), ('230106', 'PACHIA', '2301', '23'), ('230107', 'PALCA', '2301', '23'), ('230108', 'POCOLLAY', '2301', '23'), ('230109', 'SAMA', '2301', '23'), ('230110', 'CORONEL GREGORIO ALBARRACIN L', '2301', '23'), ('230200', 'CANDARAVE', '2302', '23'), ('230201', 'CANDARAVE', '2302', '23'), ('230202', 'CAIRANI', '2302', '23'), ('230203', 'CAMILACA', '2302', '23'), ('230204', 'CURIBAYA', '2302', '23'), ('230205', 'HUANUARA', '2302', '23'), ('230206', 'QUILAHUANI', '2302', '23'), ('230300', 'JORGE BASADRE', '2303', '23'), ('230301', 'LOCUMBA', '2303', '23'), ('230302', 'ILABAYA', '2303', '23'), ('230303', 'ITE', '2303', '23'), ('230400', 'TARATA', '2304', '23'), ('230401', 'TARATA', '2304', '23'), ('230402', 'CHUCATAMANI', '2304', '23'), ('230403', 'ESTIQUE', '2304', '23'), ('230404', 'ESTIQUE-PAMPA', '2304', '23'), ('230405', 'SITAJARA', '2304', '23'), ('230406', 'SUSAPAYA', '2304', '23'), ('230407', 'TARUCACHI', '2304', '23'), ('230408', 'TICACO', '2304', '23'), ('240000', 'TUMBES', '2400', '24'), ('240100', 'TUMBES', '2401', '24'), ('240101', 'TUMBES', '2401', '24'), ('240102', 'CORRALES', '2401', '24'), ('240103', 'LA CRUZ', '2401', '24'), ('240104', 'PAMPAS DE HOSPITAL', '2401', '24'), ('240105', 'SAN JACINTO', '2401', '24');
INSERT INTO `tb_distrito` VALUES ('240106', 'SAN JUAN DE LA VIRGEN', '2401', '24'), ('240200', 'CONTRALMIRANTE VILLAR', '2402', '24'), ('240201', 'ZORRITOS', '2402', '24'), ('240202', 'CASITAS', '2402', '24'), ('240300', 'ZARUMILLA', '2403', '24'), ('240301', 'ZARUMILLA', '2403', '24'), ('240302', 'AGUAS VERDES', '2403', '24'), ('240303', 'MATAPALO', '2403', '24'), ('240304', 'PAPAYAL', '2403', '24'), ('250000', 'UCAYALI', '2500', '25'), ('250100', 'CORONEL PORTILLO', '2501', '25'), ('250101', 'CALLERIA', '2501', '25'), ('250102', 'CAMPOVERDE', '2501', '25'), ('250103', 'IPARIA', '2501', '25'), ('250104', 'MASISEA', '2501', '25'), ('250105', 'YARINACOCHA', '2501', '25'), ('250106', 'NUEVA REQUENA', '2501', '25'), ('250200', 'ATALAYA', '2502', '25'), ('250201', 'RAYMONDI', '2502', '25'), ('250202', 'SEPAHUA', '2502', '25'), ('250203', 'TAHUANIA', '2502', '25'), ('250204', 'YURUA', '2502', '25'), ('250300', 'PADRE ABAD', '2503', '25'), ('250301', 'PADRE ABAD', '2503', '25'), ('250302', 'IRAZOLA', '2503', '25'), ('250303', 'CURIMANA', '2503', '25'), ('250400', 'PURUS', '2504', '25'), ('250401', 'PURUS', '2504', '25');
COMMIT;

-- ----------------------------
-- Records of tb_empleado
-- ----------------------------
BEGIN;
INSERT INTO `tb_empleado` VALUES ('1', 'JOSÉ', 'TEJADA', 'VILCA', '42513669', 'jtejadavilca@gmail.com', '150101', null, '001001', '4316658', '987597372', null, '1989-04-30', '1');
COMMIT;

-- ----------------------------
-- Records of tb_marca
-- ----------------------------
BEGIN;
INSERT INTO `tb_marca` VALUES ('1', 'KMila', '1'), ('2', 'Miguelito', '1'), ('3', 'Renzo Costa', '1');
COMMIT;

-- ----------------------------
-- Records of tb_menu
-- ----------------------------
BEGIN;
INSERT INTO `tb_menu` VALUES ('1', 'm01', 'Mantenimiento de Clientes', 'En este módulo podrá Agregar, Editar y Eliminar datos de los clientes.', 'customers.png', '0', 'mto_clientes', '1', '0'), ('2', 'm02', 'Mantenimiento de Productos', 'En este módulo podrá Agregar, Editar y Eliminar datos de los productos de la tienda.', 'productos.jpg', '0', 'mto_productos', '1', '0'), ('3', 'm03', 'Mantenimiento de Proveedores', '	En este módulo podrá Agregar, Editar y Eliminar datos de los proveedores.', 'proveedor.jpg', '0', 'mto_proveedores', '1', '0'), ('4', 'm04', 'Mantenimiento de Usuarios', 'En este módulo podrá Agregar, Editar y Eliminar datos y roles de los distintos usuarios del sistema.', 'users.jpg', '0', 'mto_usuarios', '1', '0'), ('5', 'm05', 'Configuración del Sistema', 'En este módulo podrá realizar las configuraciones generales del sistema.', 'btn-config.jpg', '0', 'mto_configuracion', '1', '0'), ('6', 'm06', 'Módulo de Caja', 'Desde este módulo, se podrán confirmar las ventas realizadas por los vendedores por parte de cajeros y administradores del sistema.', 'venta.jpg', '0', 'caja_ventas', '1', '0'), ('7', 'm07', 'Reportes', 'Desde este módulo se podrán visualizar los reportes.', null, '0', 'reportes_ventas', '1', '0'), ('8', 'm08', 'Módulo de Ventas', 'Desde este módulo se podrán ingresar las ventas.', 'venta.jpg', '0', 'mod_venta', '1', '0');
COMMIT;

-- ----------------------------
-- Records of tb_menu_rol
-- ----------------------------
BEGIN;
INSERT INTO `tb_menu_rol` VALUES ('2', '1', '1', '1'), ('3', '2', '1', '1'), ('4', '3', '1', '1'), ('5', '4', '1', '1'), ('6', '5', '1', '1'), ('7', '6', '1', '1'), ('8', '6', '2', '1'), ('9', '7', '2', '1'), ('10', '7', '3', '1'), ('11', '8', '3', '1'), ('12', '7', '1', '1');
COMMIT;

-- ----------------------------
-- Records of tb_oferta_combo
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Records of tb_oferta_combo_detalle
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Records of tb_oferta_descuento
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Records of tb_producto
-- ----------------------------
BEGIN;
INSERT INTO `tb_producto` VALUES ('1', '1', '2', 'PJ-0000106', 'PANTALON JEAN BEN-10', 'Pantalon jean ben-10', '005002', '004003', '12', '001001', '15', '30', '1'), ('2', '1', '2', 'PJ-0000108', 'PANTALON JEAN BEN-10', 'Pantalon jean ben-10', '005002', '004004', '12', '001001', '15', '30', '1'), ('3', '1', '2', 'PJ-0000206', 'PANTALON JEAN SPIDER MAN', 'Pantalon jean de Spider Man', '005002', '004003', '12', '001001', '25', '35', '1');
COMMIT;

-- ----------------------------
-- Records of tb_proveedor
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Records of tb_proveedor_producto
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Records of tb_reporte
-- ----------------------------
BEGIN;
INSERT INTO `tb_reporte` VALUES ('1', 'rpt_ventas_fecha_usuarios', 'Reporte de venta por fecha y usuario', 'Reporte que muestra las ventas en un rango de fecha ingresada y puede ser por un usuario o todos.', '1'), ('2', 'rpt_venta_detalle_fecha_usuarios', 'Reporte de venta detallada por fecha y usuario', 'Reporte que muestra las ventas con detalle en un rango de fecha ingresada y puede ser por un usuario o todos.', '1');
COMMIT;

-- ----------------------------
-- Records of tb_rol
-- ----------------------------
BEGIN;
INSERT INTO `tb_rol` VALUES ('1', 'Admin', '1'), ('2', 'Cajero', '1'), ('3', 'Vendedor', '1');
COMMIT;

-- ----------------------------
-- Records of tb_rol_reporte
-- ----------------------------
BEGIN;
INSERT INTO `tb_rol_reporte` VALUES ('1', '1', '1', '1'), ('2', '1', '2', '1');
COMMIT;

-- ----------------------------
-- Records of tb_subcategoria
-- ----------------------------
BEGIN;
INSERT INTO `tb_subcategoria` VALUES ('1', '1', 'Pantalones Jean Niño', '1'), ('2', '2', 'Camisas de Colegio', '1'), ('3', '3', 'Vestido de Gala', '1'), ('4', '4', 'Chompas de Alpaca', '1'), ('5', '5', 'Casacas Polares', '1');
COMMIT;

-- ----------------------------
-- Records of tb_usuario
-- ----------------------------
BEGIN;
INSERT INTO `tb_usuario` VALUES ('1', 'admin', 'admin', '1', '1', '003001', '1'), ('3', 'cajero', 'cajero', '1', '2', '003002', '1'), ('4', 'vendedor', 'vendedor', '1', '3', '003003', '1');
COMMIT;

-- ----------------------------
-- Records of tb_venta
-- ----------------------------
BEGIN;
INSERT INTO `tb_venta` VALUES ('1', null, '4', '2013-03-17 21:30:43', '006002', '1');
COMMIT;

-- ----------------------------
-- Records of tb_venta_detalle
-- ----------------------------
BEGIN;
INSERT INTO `tb_venta_detalle` VALUES ('1', '1', '1', null, null, '2', '30', '1'), ('2', '1', '2', null, null, '3', '30', '1');
COMMIT;
